Write down the syntax and an example for create, rename and delete index?
No Answer is Posted For this Question
Be the First to Post Answer
What are character string data types in ms sql server?
What is BCP? When do we use it?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is partition in sql server?
What happens if you add a new index to large table?
How optimize sql query with multiple joins in sql server?
What are the transaction properties?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
What is BLOCK statements in SQL?
What is acid db?
what is dbcc? : Sql server database administration
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?