Viewing 15 posts - 61 through 75 (of 93 total)
tried case
SELECT NAME ,
CASE WHEN id = 4
...
March 21, 2013 at 11:45 am
I got the answer
Beginning with SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10-6, of a second) and the amount of CPU...
February 21, 2013 at 4:03 am
I have completed the profiling and now have all the data in table 🙂
I am using following query to extract results. I have observed that for statements data is saying...
February 20, 2013 at 10:51 am
thank you very much SSCrazy. These queries are really great to have. Can I modify these queries to extract queries executed by specific user?
I want to use profiler too, as...
February 19, 2013 at 6:10 am
Lowell (10/15/2012)
first, doa SELECT * FROM sys.traces; you'll probably see traceid = 1(the default trace) plus any other traces you have created (2,3,4 etc)
select the trace id...
October 15, 2012 at 12:34 pm
not sure about your exact problem.
can't you use "AS" in your select statement ?
select column as Date from ...
July 19, 2012 at 9:37 am
thank you all.
problem resolved by adding Local to cursor declaration. I assume that by default cursor declaration is locl.
DECLARE Color CURSOR Local FOR
SELECT cc.colorid
FROM dbo.tblColor cc
July 19, 2012 at 9:27 am
thank you opc.three. it is a great tool 🙂
June 1, 2012 at 10:54 am
true Lowell.
I have tested it on TSQL, when I declare variable as varchar , it has implicit conversion as int it has not but start showing other predicate 🙁
March 20, 2012 at 12:04 pm
Viewing 15 posts - 61 through 75 (of 93 total)