这样的语句在检查SQL语法时通过,但要保存视图就提示ODBC错误,为什么??
DECLARE @from datetime DECLARE @to datetime
SET @from =
(SELECT MAX(diagnosetime)
FROM personentrance)
SET @to =
(SELECT MIN(diagnosetime)
FROM personentrance)
SELECT *
FROM personentrance
WHERE diagnosetime >= @from