/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 vote336 views1 answer
Sql beginning of previous month
SQL
0 vote383 views1 answer
Get role postgres
SQL
1 vote339 views1 answer
Media sql
SQL
0 vote391 views1 answer
Java sql timestamp now
SQL
0 vote384 views2 answers
List all constraints in postgres
SQL
0 vote371 views1 answer
Selecting Multiple Columns in SQL
SQL
20 votes390 views4 answers
How to find average in sql
SQL
0 vote408 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote350 views1 answer
Create database store
SQL
4 votes345 views1 answer
Id primary key auto generated
SQL

Share