what is the difference between Delete and Truncate
Answer Posted / manoj pandey
Check following blog post for Difference Delete vs Truncate: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a natural primary key?
What are the different types of backups that exist?
What are different backups available in sql server?
What is 3nf normalization form?
What are the disadvantages of primary key and foreign key in SQL?
What is cursors?
What do you mean by authentication modes in sql server?
Explain what is sql server english query?
how would you improve etl (extract, transform, load) throughput?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Can we add an identity column to decimal datatype?
What is data file in computer?
How will you hide an attribute? : sql server analysis services, ssas
What are the different ways you can create databases in sql server?
How much space does sql server 2016 take?