How to create a simple table to test triggers in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How do you test your database? : sql server database administration
how to copy only distinct data into another table which is not already exist in database?
Write a sql query to delete duplicate records from a table called table1
How to use order by with union operators in ms sql server?
Explain the phases a transaction has to undergo?
How to transfer data from a cursor to variables with a "fetch" statement?
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
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Why SQL Agent is used?
what is the difference between a primary key and a unique key? : Sql server database administration
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
How are the unique and primary key constraints different?