is it right way declarring table variable in transaction block in sql code example Example: sql declare table variable DECLARE @TABLE TABLE( COL1 INT, COL2 VARCHAR(30))