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

3 votes264 views1 answer
Oracle detect invalid password
SQL
0 vote269 views1 answer
Mysql select all where count more than"
SQL
3 votes269 views1 answer
Index using in query plsql
SQL
4 votes302 views1 answer
List tables sqlite
SQL
1 vote311 views1 answer
Sql set auto increment back to 0
SQL
1 vote294 views3 answers
Connection string mysql
SQL
0 vote274 views1 answer
Pl/sql loop example
SQL
1 vote270 views1 answer
Input in mysql
SQL
10 votes286 views2 answers
Linux command line import mysql database
SQL
0 vote295 views1 answer
Change magento database url usimg musql
SQL