Hi
I have a MDF file from MSSQL serwer 2000. Is there any possibilty to read data from this file using any free program.
Can PostgreSQL read it??
Hi,
Since a while I'm messing arround trying to build a "Split Function" in SQL Server:
declare @value nvarchar(50)
declare @splitter nvarchar(50)
declare @delimit nvarchar(1)
select ...
Sorry about the Question title, didn't know exactly how to call it...
I have a table called consults:
Name, Last Name, email
And a table called Users:
Name, Last Name, email
I n...
Hi,
Can Explain what is below mode:
Lock_mode is one of:
ROW SHARE
ROW EXCLUSIVE
SHARE UPDATE
SHARE
SHARE ROW EXCLUSIVE
EXCLUSIVE.
Regards
GT
Hello, I'm a total SQL beginner, learning fast but needing some help with a report I'm creating.
The report is for a job ledger and the SQL table includes JobNo, Date, CostCode, TotalCost a...
While trying to install MSDE, I received an error 'A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setu...
Hi,
I am using "DB2 v8.1.14.292" version of DB2 on windows XP SP2 machine.
While starting the m/c, I m getting the SQL6031N error:
Error in db2nodes.cfg file at line no "" reason code "...
If I already have data in the table, how to change the column name? Thanks!
hello
i am working on an MS SQL db remotely via enterprise manager. (a web site running MS SQL)
But the enterprise manager is very unreliable, alwasy breaking connections.
We would like...
How many records can a Microsoft Access 2003 database handle?
I know there is a 'practical' limit of 2Gb fize size, but for a 4 field per record database can anyone tell me a rough number? ...
Hi friends
I want to lock the table using the query in oracle so can any body tell how I will do the same I know how to lock the table in SQLServer as
begin transaction
update <tabl...
I want to know the exact difference between DBMS and RDBMS.
what is the advantage of having relationships in a Database Management System
Hi there! Is it possible to disable transaction logging for a particular query? I have a couple stored procs that do some inserts/deletes from some temp tables that aren't too important - bu...
I need some clarification on the differences between odbc, oledb and ado -
as I understand it and have used odbc basically sits in between the web server and database server for it's conne...
Hi,
I am designing a conference management system, I have not determined which database to use and would desperately like to know what are the main advantages/disadvantages to implmenting s...
I have 4 machines in our boxing warehouse, they use FEDEX Ship software and an ODBC to connect to our database. I set up all the ODBC the same but one machine (no different then the rest) is ...
Hi,
I wanted to know the major differences between MySQL and ORACLE.
Thanks in advance
Hallo everybody,
I have a problem with the List Item object
in the Oracle forms.
How can I retrieve the selected item(s) from
a list ?
I didn't find any function like 'list.GET_
SELECTE...
Hi guys,
I need help!!! I created a linked server that connects to Access Database but when I call the page from the browser it shows me this error
Cannot initialize the data source object...
Hi There,
I had asked a question related to something like this before but never got to the bottom of it. I am hoping someone can help me this time.
I have a text field with in this field...
Hi All,
Its silly, but your input is apriciated:
I need to update field 'CallerNumber' where is NULL in database to become 011666666
Please correct the following query:
update dbo.Tabl...
hi there
I have the following query and its output:
1 SELECT A.NAME,COUNT(COURSE_ID)
2 FROM SUBJECT_AREA A, COURSE
3 WHERE A.SUBJECT_AREA_ID =COURSE.SUBJECT_AREA_ID
4* GROU...
Hi,
I have an Oracle 9i server. I want to change the "system" password for the same and I am not aware of the old password.
Please suggest how I can do the same.
Regards,
I have the following query:
select a.file_job, Cntr=count(cont_num), CntrOut=count(date_out), CntrIn=count(date_in), Status=''
from cargodetailcontainer a join cargodetail b on a.file_jo...
