我正在尝试在存储过程中执行以下操作。
DECLARE @TICKET_AGE INT
SELECT @TICKET_AGE = TOP 1 (DATEDIFF(second, DATE_ENTERED, GETDATE())/60) AS TICKET_AGE
FROM TICKETS
但是它报错了,显示“INCORRECT SYNTAX NEAR 'TOP'”,我哪里做错了?
所以我更新了我的代码,现在看起来像下面这样...但现在出现了“Incorrect syntax near the keyword 'AS'.”的错误。
-- DECLARE VARIABLE
DECLARE @TICKET_AGE INT
-- PULL THE DATA
SELECT TOP 1 @TICKET_AGE = (DATEDIFF(second, DATE_ENTERED, GETDATE())/60) AS TICKET_AGE
FROM TICKETS
WHERE LOWER(STATUS_DESCRIPTION) LIKE '%new%'
ORDER BY DATE_ENTERED ASC