query using variables return table code example

Example: sql declare table variable

DECLARE @TABLE TABLE( COL1 INT, COL2 VARCHAR(30))