Differentiate between truncate vs delete in mssql?

Question Posted / mayur gupta

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

More SQL Server Interview Questions

What is indexing explain it with an example?

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

What is the benefit of normalization?

How to find the version of sql server? : sql server database administration

What happens to a trigger with multiple affected rows?

Why do we use functions?

What is rolap and its advantage? : sql server analysis services, ssas

What is transact-sql language?

How can we get count of the number of records in a table?

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

can foreign key take role of primary key?

How to insert and update data into a table with "insert" and "update" statements?

For more SQL Server Interview Questions Click Here