please differentiate between delete and truncate?
No Answer is Posted For this Question
Be the First to Post Answer
What is raiseerror? What is raiseerror?
To find second largest salary in Employee table
Can the “if update (colname)” statement be used in a delete trigger?
What is dirty read?
Can a table be created inside a trigger?
Explain what are the different index configurations a table can have?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
What is NOT NULL Constraint in sql server 2012?
How to end a stored procedure properly in ms sql server?
What is the sql case statement used for? Explain with an example?
How to select some specific columns from a table in a query in ms sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration