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 vote314 views1 answer
Mysql select all table that have field names
SQL
5 votes279 views1 answer
Postgres upsert
SQL
1 vote305 views1 answer
Oracle lock user
SQL
27 votes332 views3 answers
Mysql show tables in database
SQL
1 vote295 views1 answer
Oracle lowercase
SQL
9 votes315 views4 answers
How to create new user and database postgresql in ubuntu
SQL
1 vote305 views1 answer
Mysql count words
SQL
3 votes318 views1 answer
Force using index plsql
SQL
1 vote301 views2 answers
Mysql does sentance contain word
SQL
0 vote327 views2 answers
Py sqlite if entry exists
SQL