Browse by Tags

All Tags » statement   (RSS)
SQL Server get current executing statements - SP_WHO or SP_WHO2 or sys.dm_exec_requests
30 July 08 09:43 AM | SQL Master | 2 Comments   
As a SQL Server user or DBAs using SP_WHO or undocumented stored procedure SP_WHO2 is a common occurrence. For this there are times when you will need to run sp_who on your SQL Server to figure out who is on and what are they doing. The output is quite Read More...
Understanding Single quotes within a SELECT statement
19 February 08 12:19 PM | Madhivanan | 3 Comments   
This is for newbies who struggle to understand how single quotes work in SQL Server I have seen newbies worrying why the following doesnt work SELECT columns from mytable where col = 'Lifco' s ' When you specify a value which has single quote , you need Read More...