declare variable in stored procedure sql server 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);

Example 3: how to declare a variable in sql

DECLARE @COURSE_ID AS INT, @COURSE_NAME VARCHAR (10);

Tags:

Sql Example

Related