T-声明变量时出现SQL错误

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

当我执行上面的代码时，我得到错误。我看到了@ID打印，然后它消失了，我得到了以下消息。

“必须声明标量变量"@Key”

“必须声明标量变量"@indicator”

“必须声明标量变量"@date”

表中的数据类型: ID = nvarchar(14)，key = int，indicator = varchar(1)，date = timestamp

Answer 1

Go将结束作用域并销毁变量。

请改用;

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