What is difference between delete & truncate commands?


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

Post New Answer

More SQL Server Interview Questions

What is an Index?

3 Answers   Yardi Software,


What is clustered vs nonclustered index?

0 Answers  


How m-m relationships are implemented?

2 Answers  


How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  


How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,


What is ddl command?

0 Answers  


How do I find query history in sql server?

0 Answers  


How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  


Explain what you mean by 3 tier architecture.

0 Answers   TCS,


What is de-normalization and when do you do it?

3 Answers  


there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  


how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  


Categories