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 vote159 views1 answer
Liquibase alter column type / length
SQL
-1 vote146 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote168 views2 answers
How to drop mili second in sql
SQL
0 vote140 views1 answer
Postgresql find missing id
SQL
0 vote170 views1 answer
Psql no such file or directory
SQL
3 votes171 views5 answers
Foreign keys
SQL
0 vote169 views1 answer
Database db connection string format
SQL
1 vote233 views1 answer
Primary key reset in SQL database
SQL
3 votes161 views2 answers
Truncate table
SQL
3 votes102 views4 answers
Show columns from table
SQL