Sunday, February 10, 2019

SQL Server - Truncate/Clear table variable in Sql Server



declare @TableCount TABLE (a INT);


To delete contents of above table variable

use the following command

DELETE FROM @TableCount
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...