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 vote265 views2 answers
Full join
SQL
0 vote280 views1 answer
How to subquey to do not load in live database in
SQL
0 vote244 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote233 views1 answer
Sqlalchemy query return only n results
SQL
0 vote231 views1 answer
Mariadb used space
SQL
1 vote187 views1 answer
Strict in postgres SQL
SQL
16 votes253 views6 answers
Python sqlite
SQL
0 vote245 views1 answer
Sql convert unix time to date
SQL
0 vote241 views1 answer
Hashpass
SQL
0 vote260 views1 answer
Oracle chain step succeeded
SQL