Can a cursor be updated? If yes, how you can protect which columns are updated?
Determine when to use stored procedure to complete sql server tasks?
What is blocking and how would you troubleshoot it? : sql server database administration
whate is advantages of sql server 2000
How to set database to be single_user in ms sql server?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Can sql servers linked to other servers like oracle?
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is sql language?
What is the security model used in sql server 2005?
How to invoke a trigger on demand?
WHAT IS UNIQUE IDENTIFIER DATA TYPE?