create variable in stored procedure 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);

Example 4: declare value in sql

DECLARE  { @LOCAL_VARIABLE[AS] data_type  [ = value ] }

Tags:

Sql Example

Related