Declare table variable sql server

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
);

Source: sqlservertutorial.net

Similar codes

1 vote282 views1 answer
Minus vs intersect in sql
SQL
8 votes301 views4 answers
Mysql update one table from another table multiple columns
SQL
4 votes374 views1 answer
Oracle table statistics
SQL
16 votes306 views4 answers
Sort by sql
SQL
0 vote311 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote340 views1 answer
Gcloud sql list databases
SQL
36 votes372 views6 answers
Change column data type sql
SQL
0 vote311 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote294 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote322 views2 answers
Postgresql variable in query
SQL