Answer Posted / manoj pandey
DELETE vs TRUNCATE
Check: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
~Manoj
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is subquery? Explain the properties of a subquery?
Why should you use or avoid select * statements?
What is self contained sub query?
How do I find the sql server version?
Does view occupy space?
How can I check that whether automatic statistic update is enabled or not?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can we do dml on views?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is sql or structured query language?
How to convert character strings into numeric values?
Can sql servers link to other servers like oracle?
What is clustered index
What is the difference between for xml raw and for xml auto?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
