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 votes315 views1 answer
Apex date today add days
SQL
10 votes327 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote330 views1 answer
Convert rows to columns in sql server
SQL
1 vote292 views1 answer
Sql auto timestamp
SQL
0 vote335 views2 answers
Mysql on update current_timestamp
SQL
0 vote309 views1 answer
Backup a table in sql
SQL
1 vote326 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
4 votes331 views1 answer
Search column by name mysql
SQL
3 votes359 views1 answer
Sql set null
SQL
0 vote348 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL