Viewing 15 posts - 346 through 360 (of 1,253 total)
Column cpu in sysprocesses show the cpu time taken for a particular process (spid). Its in milliseconds.
March 16, 2009 at 1:17 am
If you want to export data to a excel file you need to be looking at the bcp utility.
March 16, 2009 at 1:14 am
Steve Jones - Editor (3/12/2009)
March 13, 2009 at 1:22 am
BULK INSERT checkcsv
FROM 'C:\foldername\IWSQLDBame.txt'
WITH
(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')
Specify the correct drive where i have put "C:\" and put the correct folderpath in "foldername" and try.
March 13, 2009 at 1:16 am
Hi... my rough and tough idea... sorry if it seems clumsy
Script out a certain number of procedures into SSMS and do a find and replace.
March 12, 2009 at 5:54 am
You need to put the file either on the db server or another server (UNC) which the db server can access.
In your case put it in the C drive of...
March 12, 2009 at 5:50 am
Why 4 points for this question? I mean u can run this thing in SSMS and get the answer.
March 12, 2009 at 2:18 am
Do you mean to say u put indexes on the columns and the query worked better?
March 12, 2009 at 2:16 am
manju_gallivant (3/10/2009)
It is correlated sub query ..
if the inner sub query returns u multiple rows.. the update query actually loops thru the resultset and updates...
March 11, 2009 at 6:40 am
Hi
Its difficult to tell without knowing exactly what you are trying to do. With the info given i think using of temp tables might be the best of the 3...
March 11, 2009 at 2:28 am
Can we write a update query like the way you have written
"UPDATE TIDLRREP t SET (t.translated_term_79, t.repository_status) =
(SELECT a.TRANSLATED_TRM_160,'40' FROM ..."
Are'nt you getting any errors?
March 10, 2009 at 12:00 am
shankaran_sraj (3/9/2009)
To get Third highest value..Try this..
SELECT MAX(col_name) FROM Table1 A
WHERE 3 = (SELECT COUNT(*)+1 FROM Table1 B WHERE A.Col_name< B.Col_name)
Will work only of numeric/integer columns. If the data...
March 9, 2009 at 11:50 pm
Hey buddy we are not here to waste time. Rather we are here to help each other. Since you got the solution you should post it here and close the...
March 9, 2009 at 3:15 am
Yes its only for the current session. DateFirst acutally depends on the language chosen. For english it 7 - Sunday.
March 9, 2009 at 3:11 am
Viewing 15 posts - 346 through 360 (of 1,253 total)