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 vote187 views1 answer
Mac mysql workbench console
SQL
3 votes173 views1 answer
How to remove characters from string in mysql
SQL
1 vote180 views1 answer
Sample clause in sql
SQL
0 vote177 views3 answers
Sql parenthetical expression examples
SQL
1 vote202 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote175 views1 answer
Select top 3 sql
SQL
0 vote196 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote175 views1 answer
MySql get primary keys of table
SQL
5 votes191 views3 answers
Sql max value in column
SQL
0 vote178 views1 answer
Truncate table sql server foreign key
SQL