What is difference between TRUNCATE and DELETE statement
Answer Posted / nageswarao
truncate is used for deleting all data from table.
it is similar to delete command without condition.
main differences b/w delete & truncate are
1.truncate is faster in execution than delete which will
restructure the complete table without bothering of data.
where as delete checks the data row by row wrotes
information into log and deletes.
2.with truncate we cannot use any conditions
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What are the aggregate and scalar functions?
What is rolap and its advantage? : sql server analysis services, ssas
What is scrollable cursor?
How to create a new login name in ms sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is the exact numeric data type in sql?
What is system stored procedures?
what is checksum in sql server.........???
What is save transaction and save point?
Define Unique Key?
How to find out the list schema name and table name for the database?
can a table be moved to different filegroup? : Sql server administration
What is difference between joins and subqueries?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.