Is there a built in oracle function that will give the number of days since a certain (built in oracle) date? eg given 01/01/2000 it would return a number representing the number of days since...
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,
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 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...
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,
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 ...
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...
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??
Hello,
How do I change a user password in DB2? I have the db2admin password but I don't have the password of one of the users.
Thanks
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...
If I already have data in the table, how to change the column name? Thanks!
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,
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...
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...
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 "...
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 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 ...
I want to know the exact difference between DBMS and RDBMS.
what is the advantage of having relationships in a Database Management System
hello experts,
Please tell me how to get the output of 2 lines in same line using pl/sql's dbms.output.
by default it gives next outupt in next line.
waiting..
Thanks.
The result is same sometime but what is the key diffrence betweem 2?
I have just installed Oracle Enterprise Edition, i tried to run SQL Plus. I requested username and password. I googled and by chance i found username should be scott and password is tiger whic...
Hi,
I have to compare two strings using Oracle SQL to see if they are similar.
For example, the title of a song in one table might be 'White and Nerdy', in another 'WHITE AND NERDY' or 'W...
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...
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? ...
OS - Windows XP Pro SP2
MSDE Client in Question - SP3
Scenario:
When attempting to install MSDE, I receive the error "Setup has failed to configure your server. Refer to the server erro...
