How to Update from select query in sql server?
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
how many types of store procedre in sqlserver 2000?
Describe triggers features and limitations?
Explain optimistic and pessimistic concurrency?
What is difference between TRUNCATE and DELETE statement
What are the different types of locks in the database?
What is the partitioning method?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Is it ok to shrink transaction log?
Which databases are part of SQL server default installation? Explain the usage of each?
What are the character string functions supported by sql server 2005?
How do you run a trace?