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

0 vote138 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote139 views1 answer
How to select an index in oracle sql
SQL
0 vote132 views1 answer
How to check default value of column in sql server
SQL
10 votes133 views6 answers
Between sql
SQL
0 vote126 views1 answer
Soql more than today
SQL
0 vote132 views1 answer
Postgresql on conflict pair
SQL
7 votes139 views1 answer
Xampp reset mysql
SQL
0 vote141 views1 answer
Select into table variable
SQL
0 vote128 views2 answers
Sql day from datetime
SQL
2 votes204 views2 answers
Mysql compare datetime to another datetime
SQL