How can I know what query is executing by by a particural user? (using sp id or any othe way.)
2 4830i 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 70769. 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 4048One 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 3798Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
8 12241
Explain about SQL server 2005?
List the different index configurations possible for a table?
What are character string data types in ms sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Is the log file is a part of file group?
How to drop an existing table with "drop table" statements in ms sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is the difference in accessing db between sql server vs sql azure?
Is port 1433 secure?
What protocol does sql server use?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What do you mean by authentication modes in sql server?
What is difference between unique and primary key?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How much memory that we are using in Logshipping Concept?