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 vote172 views1 answer
Openquery insert into linked server
SQL
0 vote168 views1 answer
Psql check if value in array
SQL
0 vote176 views1 answer
Create query in where clasue
SQL
10 votes181 views6 answers
Mysql delete duplicates
SQL
0 vote170 views2 answers
Mysql create table if not exists
SQL
2 votes174 views1 answer
Set username and password for postgresql database
SQL
4 votes297 views6 answers
Laravel jwt
SQL
2 votes183 views2 answers
Postgres add column integer
SQL
0 vote181 views1 answer
Sql declare variable single line
SQL
0 vote177 views1 answer
Guid string to binary better
SQL