What is the difference between truncate and delete commands?


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

Post New Answer

More SQL Server Interview Questions

How to return the second 5 rows in ms sql server?

0 Answers  


How can I create a report based on a query? : sql server management studio

0 Answers  


Is the primary key column of a table an index in ms sql server?

0 Answers  


How to receive returning result from a query?

0 Answers  


Why use “pivot” in sql server?

0 Answers  






How to create new tables with "select ... Into" statements in ms sql server?

0 Answers  


employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  


How to truncate the log in sql server 2012? : sql server database administration

0 Answers  


Do comments need to go in a special place in sql server 2005?

0 Answers  


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


do you know how to configure db2 side of the application? : Sql server database administration

0 Answers  


Categories