Wednesday, March 11, 2009

Truncate Table and Verify Truncate

SELECT COUNT(*) AS BeforeTruncateCount
FROM DBO.MyTable

TRUNCATE TABLE DBO.MyTable

SELECT COUNT(*) AS AfterTruncateCount
FROM DBO.MyTable
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)