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 vote212 views1 answer
Sql trying to delete database in use
SQL
0 vote210 views2 answers
Sql join on comma separated field
SQL
0 vote198 views1 answer
Install mysql 8 linux
SQL
2 votes206 views1 answer
Mysql cannot delete or update a parent row
SQL
12 votes213 views2 answers
Delete all nodes neo4j
SQL
0 vote218 views1 answer
My sql data file extention
SQL
1 vote207 views1 answer
Get url of cpanel database hostname
SQL
1 vote219 views1 answer
Pagination sql
SQL
0 vote158 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote207 views1 answer
Mysql 1 hour ago
SQL