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

DECLARE @table_variable_name TABLE (<br /><br /><br /><br /> column_list<br /><br /><br /><br /> );</p><br /><br /><br /> <p>Example:<br /><br /><br /><br /> DECLARE @product_table TABLE (<br /><br /><br /><br /> product_name VARCHAR(MAX) NOT NULL,<br /><br /><br /><br /> brand_id INT NOT NULL,<br /><br /><br /><br /> list_price DEC(11,2) NOT NULL<br /><br /><br /><br /> );

DECLARE @ListOWeekDays TABLE(DyNumber INT,DayAbb VARCHAR(40) , WeekName VARCHAR(40))</p><br /><br /><br /> <p>INSERT INTO @ListOWeekDays<br /><br /><br /><br /> VALUES<br /><br /><br /><br /> (1,’Mon’,’Monday’) ,<br /><br /><br /><br /> (2,’Tue’,’Tuesday’) ,<br /><br /><br /><br /> (3,’Wed’,’Wednesday’) ,<br /><br /><br /><br /> (4,’Thu’,’Thursday’),<br /><br /><br /><br /> (5,’Fri’,’Friday’),<br /><br /><br /><br /> (6,’Sat’,’Saturday’),<br /><br /><br /><br /> (7,’Sun’,’Sunday’)<br /><br /><br /><br /> SELECT * FROM @ListOWeekDays

DECLARE @TableVariable TABLE (Id INT)</p><br /><br /><br /> <p>INSERT INTO @TableVariable<br /><br /><br /><br /> SELECT Id<br /><br /><br /><br /> FROM TableName<br /><br /><br /><br /> WHERE….</p><br /><br /><br /> <p>SELECT *<br /><br /><br /><br /> FROM TableName<br /><br /><br /><br /> WHERE Id IN ( SELECT Id FROM @TableVariable)

— name type value<br /><br /><br /><br /> DECLARE @PersonId AS UNIQUEIDENTIFIER = ‘ddb7bfff-9ce8-4651-6973-08d9a46c90b6’

DECLARE @datecurrent datetime2<br /><br /><br /><br /> set @datecurrent = CAST(getdate() AS smalldatetime)

DECLARE @COURSE_ID AS INT, @COURSE_NAME VARCHAR (10);<br /><br /><br /><br />