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

39 votes334 views5 answers
Sql drop column
SQL
0 vote280 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote268 views1 answer
C# select Mysql
SQL
1 vote259 views1 answer
Oracle lowercase
SQL
1 vote284 views1 answer
Convert varchar to int in sqlite
SQL
0 vote283 views1 answer
Sql declare variable single line
SQL
0 vote225 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote279 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
6 votes275 views1 answer
Phpmyadmin password root
SQL
1 vote286 views4 answers
Aggregate function in sql
SQL