David Emerson
newsgrps at dalyn.co.nz
Tue Jul 8 12:55:49 CDT 2008
Is it possible to truncate a temporary table in SQL2000? I have a table defines as follows: DECLARE @ttmpGoalIns TABLE (RowID int IDENTITY (1, 1) NOT NULL, GoalID int, Description varchar(100), GoalAmt money DEFAULT (0) ) During my code I want to delete the rows and reset the identity back to 1. Truncate is supposed to do this but I get an Incorrect Syntax error on the line: TRUNCATE TABLE @ttmpGoalIns Regards David Emerson Dalyn Software Ltd Wellington, New Zealand