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

2 votes84 views1 answer
Select sid oracle
SQL
0 vote154 views1 answer
Postgresql port 5432 not open
SQL
1 vote111 views1 answer
Oracle compile schema
SQL
0 vote140 views3 answers
Find below average salary in sql
SQL
0 vote186 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes132 views1 answer
Import database in mysql command line xampp
SQL
0 vote138 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote137 views1 answer
Python mysql show databases
SQL
0 vote132 views1 answer
Postgres jsonb array push new element
SQL
4 votes142 views5 answers
Primary key
SQL