declare table in stored procedure sql server code example

Example 1: 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
);

Example 2: create table variable in sql stored procedure

DECLARE @table_variable_name TABLE (
    Number int IDENTITY(1,1) ,
	Id int not null,
	[Name] nvarchar(200) NULL,
	Amount decimal(38,2) NULL
);

Example 3: declare variable in stored procedure in sql server

DECLARE 
    @product_name VARCHAR(MAX),
    @list_price DECIMAL(10,2);

Tags:

Sql Example