What is similarity and difference between truncate and delete in sql?

Question Posted / nitesh kumar

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

More SQL Server Interview Questions

How do I find information about the install locations for the various instances running on a computer?

What are the difference between “where” and “having” clause in sql server?

Can you pass expressions to stored procedure parameters?

What type of locking occurs during the snapshot generation? : sql server replication

Advantages and disadvantages of stored procedures.

Explain the rules for designing files and file groups in sql server?

What happens if an integer is too big for int date type?

What is the minimum recommended amount of ram for sql server 2012 enterprise?

What is Data model and how to prepare a data model.?

Explain what is public role in sql server?

How to use “drop” keyword in sql server and give an example?

What is the difference between migration and upgradation in sql server?

For more SQL Server Interview Questions Click Here