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 vote411 views1 answer
Sql query to select even numbers
SQL
2 votes355 views1 answer
Postgresql create schema in specific database
SQL
2 votes346 views1 answer
Oracle convert run_duration to number
SQL
0 vote341 views1 answer
Concat column value of same user in mysql
SQL
4 votes306 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote349 views1 answer
Mysql cdn link
SQL
2 votes339 views6 answers
In in sql
SQL
0 vote399 views1 answer
"Hello User Name"
SQL
0 vote370 views1 answer
SQL query to verify the size of the table
SQL
0 vote307 views1 answer
Now() -1 mysql
SQL