sql - 必须声明标量变量“@LocationId”

Question

SELECT * 
FROM dbo.vwAlarmAssetGroupLocationReport
WHERE (LocationID = CAST(COALESCE(@LocationId, LocationId) AS UNIQUEIDENTIFIER) 
       OR TopLocationId = CAST(COALESCE(@LocationId, TopLocationId) AS UNIQUEIDENTIFIER))
  AND DateCreated BETWEEN '2018-10-23 AND 2018-10-25'
  AND AssetGroupId = '8E99BAFB-739A-E411-B54B-40F2E9985B7A'
ORDER BY DateCreated

当我尝试在 SQL 中运行我的报告时，不断收到此错误消息有什么想法吗？

标签： sqlsql-servertsql

Answer 1

问题是你必须先定义LocationId。尝试在您的代码块前面添加：

DECLARE @LocationID DATATYPE
SET @LOCATION ID = VALUE