What is implicit mode in sql server?
What is temporal data type?
Explain ranking functions?
What are the Advantages of using CTE in sql server?
What is reference section?
Differences between logshipping and mirroring
How to see the event list of an existing trigger using sys.trigger_events?
How can you list all the columns in a database?
What is a Lock and let me know Different types of locks?
i 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
Can two different columns be merged into single column? Show practically?
I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output
What is a natural primary key?