sql declare something from another table function code example

Example: sql declare table variable

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