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 vote161 views1 answer
Sql select without column name
SQL
0 vote133 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
22 votes125 views6 answers
Create sql table
SQL
0 vote106 views2 answers
Get top 1 row of each group
SQL
3 votes122 views2 answers
Order by postgresql
SQL
2 votes114 views1 answer
Mysql select random id from table
SQL
13 votes114 views4 answers
Mysql get last row
SQL
2 votes112 views2 answers
Mysql on duplicate key ignore
SQL
0 vote104 views1 answer
Oracle 11g forget password
SQL
8 votes128 views1 answer
Mysql restore database
SQL