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 vote181 views1 answer
Sql check if field is not null
SQL
16 votes144 views3 answers
Tsql rename column name
SQL
4 votes131 views2 answers
Mysql how to change default charset
SQL
0 vote140 views1 answer
Sql create table with datetime automatically
SQL
0 vote179 views1 answer
Sql pivot table
SQL
0 vote154 views1 answer
Difference between db.query and db.execute
SQL
0 vote143 views1 answer
Alter table engine mysql
SQL
0 vote137 views1 answer
Select in select sql
SQL
0 vote146 views2 answers
Sql query in dax power bi
SQL
11 votes92 views1 answer
Reset identity sql server
SQL