T-SQL Error while DECLARING variables

Question

Declare @ID nvarchar(14) = '12345678912345'  
DECLARE @Key int = (SELECT  key
                           FROM    table
                           WHERE   id = @ID) 

Declare @indicator varchar(1) = 'A' 

Declare @rdate Datetime = (SELECT LTRIM(RTRIM(Left(CAST(GetDate() AS Datetime2),23))))


SELECT @ID 
GO
SELECT @Key 
GO
SELECT @indicator 
GO
SELECT @date 
GO

I get error when I execute the above code. I see @ID print and it goes away and I get the following messages.

"Must declare the scalar variable "@Key"

"Must declare the scalar variable "@indicator"

"Must declare the scalar variable "@date"

Datatypes in the table: ID = nvarchar(14), key = int, indicator = varchar(1), and date = timestamp

podiluska · Accepted Answer · 2012-09-14 14:25:42Z

2

Go will end the scope and destroy the variables.

Use a ; instead

SELECT @ID;SELECT @Key;SELECT @indicator;SELECT @rdate;

answered Sep 14, 2012 at 14:25

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

007 Over a year ago

Wow...that solved it. Now if I have a bunch of DML statements and each ends with GO, is it OK if I remove GO after each DML statements?

Collectives™ on Stack Overflow

T-SQL Error while DECLARING variables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related