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

2 votes340 views1 answer
Brew start postgres manual
SQL
1 vote356 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote344 views1 answer
How to drop a trigger in postgresql
SQL
42 votes429 views6 answers
Install beautifulsoup
SQL
4 votes355 views2 answers
Select first and last row mysql
SQL
0 vote379 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
4 votes348 views1 answer
SQL find text in SP
SQL
0 vote378 views3 answers
Select top 10 rows in sql
SQL
0 vote405 views1 answer
Mysql delete entire row on condition
SQL
0 vote372 views4 answers
Sql server date format yyyy-mm-dd
SQL