|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
what is the difference between truncate and deleteHi,
i've been using both delete and truncate a table, but don't know exactly the differences between them. Thanks Ken Hi,
without having to quote the whole BOL, you can find the bullet points of differences listed here with explanations: http://msdn2.microsoft.com/de-de/library/ms177570.aspx HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- |
|||||||||||||||||||||||
Other interesting topics