Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23396 Views
- CTS, I also Faced
- E-Mail Answers
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
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Does sql server use java?
what is an extended stored procedure? : Sql server database administration
Explain Capacity planning to create a database? and how to monitor it?
What is cross join in sql server joins?
How you can change a cross join into an inner join?
How you provide security to cube? : sql server analysis services, ssas
What is unpivot?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are the main differences between #temp tables and @table variables and which one is preferred?
What the difference between UNION and UNIONALL?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What are difference between Cluster index and Non-Cluster index?
What are truncate options available in sql server? : sql server database administration
