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 vote140 views1 answer
UseSqlServer no definition
SQL
0 vote121 views1 answer
Last date for each user sql
SQL
5 votes146 views2 answers
Get columns number sql
SQL
0 vote123 views1 answer
Best sql collation
SQL
0 vote163 views1 answer
Sqlalchemy query return only n results
SQL
2 votes130 views2 answers
Sql query to copy data from one column to another
SQL
11 votes120 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote127 views1 answer
How to create notes in mysql
SQL
16 votes126 views3 answers
Tsql rename column name
SQL
2 votes85 views4 answers
Mysql change database character set to utf8mb4
SQL