Serenity
Serenity

Reputation: 5098

Isnt this how to declare a local variable in Stored procedure?

ALTER PROC [Admin].[sp_Ques]    
(
    @QuesID bigint
 )
DECLARE @Lang int
AS
BEGIN
.
.
.

Upvotes: 0

Views: 539

Answers (1)

ClosureCowboy
ClosureCowboy

Reputation: 21531

Yes, but you must declare it after the BEGIN.

Upvotes: 2

Related Questions