How can I know what query is executing by by a particural user? (using sp id or any othe way.)
2 4206i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
8 58929. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18
2 3535One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
1 3264Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
8 10801
Where the sql logs gets stored? : sql server database administration
How to invoke a trigger on demand?
What are the different types of collation sensitivity?
Is the log file is a part of file group?
What are the steps you can take to avoid “deadlocks”?
SQL Server Architecture ?
How to install sql server 2005 express edition?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Write a code to select distinct records without using the DISTINCT keyword.
What is the significance of master, tempdb and model databases?
What is sharding?
How to name query output columns in ms sql server?
Explain the Ways to improve the performance of a sql azure database?
Do you know what is difference between index seek vs. Index scan?
How to verify a login name with sqlcmd tool?