Define right outer join in sql server joins?
How to insert multiple rows with a subquery?
what is bit data type? and what are the information that can be stored inside a bit column?
What is replication and database mirroring?
What method is used by the Command classes to execute SQL statements that return single values?
What is page-level compression?
How to delete an existing database user?
Tell me what is log shipping?
How can we remove orphan records from a table?
What is the order by used for?
What are the common performance issues in sql server?
Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance
What is the difference between deallocate cursor and close cursor?