hi friends
How to convert a date into dd/mm/yyyy fashion directly through SQL.
i know the functions day,month,year.
but is there any other format function which can directly give me a date ...
Experts,
Currenlty all DB in my company is on SQL Server 2000 and we plan to build another DB server with SQL Server 2005 to take the place.
I am wondering what is the best way to perfo...
dear club members
I want to grant "truncate table privileges" to a non owner user.
If any body know please let me know
THanks
Does any one know how I can export the results of an SQL statement straight to a text file through code.
i.e select * from tablename would immediately create a text file in a specified loc...
What is the meaning of:
"COLLATE SQL_Latin1_General_CP1_CI_AS NULL"
I am trying to create a query that gives me all people with a date of only <06/01/03. If there are people with both dates of < and > 06/01/2003, then I don't want them to show in the query. An...
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...
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.
Hi
I want to remove multiple characters (that are not necessary sequential) in a string.
To remove the character 'a' from a string I use the following:
REPLACE(mystring, 'a', '')
...
While restoring the SQL Server database, I got the message:
Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally.
Are there oth...
I have a stored procedure that receives 20 different parameters as fully built Insert queries...The potential exists though that some of those parameters may be passed to the stored-procedure ...
working in oracle and up to last night all wokred fine, but today I am getting this error and not too sure what is causing that, any help would be appreciated.
I get it everytime I create a u...
Hi all.
I created a VIEW in SQL Enterprise Manager and was wondering if I could have it accept a parameter for one of the fields(CustomerNumber), I will use this VIEW in an Access report.
...
I am trying to find a way to add some numbers to a column of data in MS SQL 2005. I am not sure if this is possible in MS SQL, but below is what I am trying to do -
UPDATE Table
SET colu...
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 ...
I have am trying to write an ASP page that pulls data from a SQL Server database, where the SQL server is on a different machine than the IIS server.
I have everything working, except when ...
Hallo,
I would like to select data from a database using 'Select * " based on a value in a row (same column)being unique.
By that I mean that that data must not repeat again. Idealy I woul...
Scenerio, I have 100 records. From the stored proc (SQL 2000), I want to pull 10 records at a time in a date order. I want to mark these records so they are not pulled a second time. Th...
Hi
I am having an ORA-00257 error when trying to connect to oracle
Can anyone share what all scenarios cause this problem and how we can fix it.I t would be fine if i get multiple fixes ...
If I already have data in the table, how to change the column name? Thanks!
I am using a specialized version of SQLPlus to generate a query and then pasting this query into another application to get the data. For these reasons the SQL functions are very limited AND ...
Error:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
Syntax error converting datetime from character string.
Data Structure:
1 event_id int 4 0
0 grade nvarchar 50 1
0 team n...
I am sure there is a simple fix for this but I can't find it. I can make a connection to mysql using mysql -u root -p without a problem and I can use mysql -h local -u root without a problem,...
This questions extends previous one re SQL Update Statement in SQL Server 2000. I have managed to replace apostrophe with ’ (due to XHTML!!). The previous field was nvarchar so arguments...
I have the following stored procedure that runs 2 sql statements, basically the statement are the same except for an additional "AND" clause when @intReg > 0.
Firstly this does not work, I ...