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

6 votes76 views1 answer
Identify primary key in oracle table
SQL
1 vote71 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
22 votes77 views3 answers
Remove all records from table mysql
SQL
2 votes81 views3 answers
Mysql pass command from command line
SQL
0 vote78 views1 answer
Get substract count sql
SQL
4 votes86 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
21 votes79 views4 answers
Oracle add column
SQL
1 vote69 views1 answer
Oracle convert run duration to number
SQL
0 vote62 views1 answer
Export partttion and import in oracle
SQL
4 votes76 views2 answers
Mysql alter table set column unique
SQL