Breaking News: Grepper is joining You.com. Read the official announcement!

declare variable in stored procedure in sql server

Add Answer

Thabiso Phetla answered on July 9, 2020 Popularity 10/10 Helpfulness 4/10

answer declare variable in stored procedure in sql server

related create table variable in sql stored procedure

related declare & set variable stored procedure

declare variable in stored procedure in sql server

Comment

        
            
        
     DECLARE 
    @product_name VARCHAR(MAX),
    @list_price DECIMAL(10,2);

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.sqlservertutorial.net

Tags: declare procedure sql sql-server

Link to this answer
Share Copy Link

Contributed on Jul 09 2020

Thabiso Phetla

0 Answers Avg Quality 2/10

Closely Related Answers

create table variable in sql stored procedure

Comment

DECLARE @table_variable_name TABLE (
    Number int IDENTITY(1,1) ,
	Id int not null,
	[Name] nvarchar(200) NULL,
	Amount decimal(38,2) NULL
);

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: procedure proc

Link to this answer
Share Copy Link

Contributed on Feb 12 2021

Ranish Patel

0 Answers Avg Quality 2/10

declare & set variable stored procedure

Comment

CREATE PROCEDURE DisplayInfo @employee_id int
AS
DECLARE

@name nchar(30),
@department nchar(30),
@age int,
@salary real

BEGIN

SET @name= (SELECT Name FROM Employees WHERE [Employee ID]=@employee_id)
SET @department= (SELECT Department FROM Employees WHERE [Employee ID]=@employee_id)
SET @age= (SELECT Age FROM Employees WHERE [Employee ID]=@employee_id)
SET @salary= (SELECT Salary FROM Employees WHERE [Employee ID]=@employee_id)
PRINT('Employee Name is:'+ @name)
PRINT('Employee Department is:'+@department)
PRINT('Employee Age is:'+STR(@age))
PRINT('Employee Salay is:'+STR(@salary))

END
GO

Popularity 6/10 Helpfulness 1/10 Language whatever

Source: databasefaqs.com

Tags: declare procedure set whatever what

Link to this answer
Share Copy Link

Contributed on Apr 13 2023

Nanu

0 Answers Avg Quality 2/10

declare variable in stored procedure in sql server

Contents

More Related Answers

declare variable in stored procedure in sql server

Closely Related Answers

create table variable in sql stored procedure

declare & set variable stored procedure

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.