sql create stored procedure with variables code example

Example 1: 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 2: declare variable in stored procedure in sql server

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