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 vote186 views1 answer
Mysql check if string contains comma separated
SQL
0 vote221 views1 answer
Delete first row in sql
SQL
19 votes192 views4 answers
Rename database in sql
SQL
0 vote212 views1 answer
Datagrip execute procedure
SQL
5 votes204 views4 answers
Change auto increment mysql
SQL
0 vote193 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote262 views1 answer
Sql get table last modified time
SQL
0 vote249 views1 answer
Sql int vs integer
SQL
0 vote226 views1 answer
Openquery update linked server
SQL
0 vote190 views1 answer
To change the database owner in SQL server
SQL