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 vote202 views1 answer
Sql change column in existing table
SQL
0 vote225 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote196 views1 answer
How to remove identity from a column in sql server
SQL
0 vote188 views1 answer
Sql select most frequent value in group
SQL
0 vote189 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote217 views1 answer
How to define a non primary composite key in sql
SQL
2 votes189 views1 answer
Anonymous block plsql
SQL
0 vote194 views1 answer
Low level operator in dbms
SQL
6 votes246 views2 answers
How to get last element sql
SQL
1 vote309 views1 answer
SQL server query column yes or no
SQL