please differentiate between delete and truncate?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is raiseerror? What is raiseerror?

0 Answers  


To find second largest salary in Employee table

17 Answers   CSS,


Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  


What is dirty read?

0 Answers  


Can a table be created inside a trigger?

0 Answers  






Explain what are the different index configurations a table can have?

0 Answers  


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?

2 Answers  


What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,


How to end a stored procedure properly in ms sql server?

0 Answers  


What is the sql case statement used for? Explain with an example?

0 Answers  


How to select some specific columns from a table in a query in ms sql server?

0 Answers  


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

0 Answers  


Categories