/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

6 votes141 views4 answers
Remove spaces sql server
SQL
0 vote142 views1 answer
Sqlserver now
SQL
3 votes193 views6 answers
Jwt laravel
SQL
7 votes131 views1 answer
Sql disable safe mode
SQL
0 vote136 views1 answer
Why mysql is used?
SQL
0 vote144 views2 answers
Return the number of records in a single table mysql
SQL
2 votes144 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
1 vote161 views1 answer
How to select random rows from a table
SQL
0 vote134 views1 answer
Postgres can integer fields be negative
SQL
0 vote147 views2 answers
How to type a blank discord messgae
SQL

Share