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 vote111 views1 answer
Apt install sql server
SQL
1 vote109 views3 answers
Reset sql primary key
SQL
0 vote108 views1 answer
Low level operator in dbms
SQL
38 votes162 views6 answers
Alter table mysql
SQL
1 vote98 views1 answer
Mysql datetime with timezone offset
SQL
0 vote154 views1 answer
Drop a view in sqlite
SQL
1 vote115 views1 answer
Sql server list locks
SQL
0 vote111 views1 answer
Consulta alias con inner join
SQL
3 votes131 views3 answers
Mysql auto increment after delete
SQL
0 vote111 views1 answer
Add super privilege mysql
SQL