What is difference between TRUNCATE and DELETE statement
Answer Posted / nirmala.s
if u use delete to remove the data from the table,this will
delete the data.after using rollback the removed data can
be retrived.But in case of, truncate , it will delete the
data and that can't ever be retrived.even after using
rollback also. but the table structure of the table will
be there
if u are using drop command , this will delete entire
table.and its structure.
Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
How to create a simple stored procedure in ms sql server?
What is the cartesian product of the table?
Can I disable or restrict ssrs export formats (rendering formats)?
How to attach adventureworkslt physical files to the server?
Why are views required in the sql server or in any other database?
How to modify an existing stored procedure in ms sql server?
What are window functions in sql server?
What is a linked server in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is the difference between clustered and a non-clustered index?
What is wrong with sql server client libarary dll, ntwdblib.dll?
How to convert binary strings into integers in ms sql server?
What is user defined datatypes and when you should go for them?
What are Spatial data types in SQL Server 2008
What is log ldf?