/SQL/Create table variable in sql stored procedure

Create table variable in sql stored procedure

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
);

1

Similar codes

0 vote161 views1 answer
Remove default constraint sql server
SQL
0 vote189 views1 answer
Mysql select all where count more than"
SQL
0 vote189 views1 answer
No suitable driver found for sqlite
SQL
1 vote172 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote180 views1 answer
Raiserror with nowait
SQL
0 vote189 views1 answer
Mysql root localhost run
SQL
0 vote199 views1 answer
Sql quary stuf
SQL
0 vote204 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
7 votes173 views5 answers
Show details of table postgres
SQL
103 votes561 views2 answers
Sql server LIKE '%%'
SQL

Share