how to use table variable in stored procedure code example
Example: 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
);