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 vote291 views2 answers
Insert into
SQL
5 votes308 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote315 views1 answer
One table with another
SQL
2 votes318 views1 answer
Sql percentage with % rounded down
SQL
1 vote311 views2 answers
Postgres select from last 3 months
SQL
7 votes310 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote313 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote316 views1 answer
How to get one year old query from plan cache
SQL
0 vote281 views1 answer
Set column width in sqlplus
SQL
0 vote321 views1 answer
How to run mysql on terminal mac
SQL