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

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,


How many databases instances are there in sql server 2000?

0 Answers  


What is the purpose of update statistics and scope_identity() function?

0 Answers  


What is the maximum size of sql server database?

0 Answers  


Can we create nonclustered index in a table without creating a clustered index

1 Answers  


Can you index views?

0 Answers  


What is a trigger?

7 Answers  


What are the properties of sub-query?

0 Answers  


What is the difference between clustered and a non-clustered index?

0 Answers   NA,


what is victor class

0 Answers  


What are the types of table?

0 Answers  


How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  


Categories