xxxxxxxxxx
DECLARE @TableVariable TABLE (Id INT)
INSERT INTO @TableVariable
SELECT Id
FROM TableName
WHERE .
SELECT *
FROM TableName
WHERE Id IN ( SELECT Id FROM @TableVariable)
xxxxxxxxxx
DECLARE @table_variable_name TABLE (
column_list
);
Example:
DECLARE @product_table TABLE (
product_name VARCHAR(MAX) NOT NULL,
brand_id INT NOT NULL,
list_price DEC(11,2) NOT NULL
);
xxxxxxxxxx
DECLARE @transactionDate AS date='2023-07-04';
DECLARE @TestVariable AS VARCHAR(100)='Save Our Planet';
PRINT @TestVariable;
PRINT @transactionDate;
xxxxxxxxxx
DECLARE @datecurrent datetime2
set @datecurrent = CAST(getdate() AS smalldatetime)