You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to invoke a trigger on demand?
How to create nested stored procedure?
Explain “row_number()” in sql server with an example?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Explain stored procedure?
When is the use of update_statistics command?
What is a field name?
What is proper subset of candidate key?
What is update_statistics command?
What are the advantages of mirroring?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
what is the information that can be stored inside a bit column? : Sql server database administration
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is ddl command?