MSSQL view 和 Query Analyzer 问题

min_n

我有一个 view 如下:

SELECT     CONVERT(smalldatetime, CONVERT(nvarchar, DeliveryTime, 112), 112) AS mydate, Originator
FROM         dbo.T_FolderMessages
WHERE     (DeliveryTime IS NOT NULL)

当我在Query Analyzer 里 run 以下的 command 时:

SELECT *
FROM (SELECT * FROM VIEW1) _IntResult
WHERE (mydate BETWEEN '2006-07-01' AND '2006-07-10')


“
(31264 row(s) affected)

Server: Msg 8115, Level 16, State 2, Line 1

谢谢！

goatstudio

你没写出你的问题出来.
另外

SELECT *
FROM (SELECT * FROM VIEW1) _IntResult
WHERE (mydate BETWEEN '2006-07-01' AND '2006-07-10')

用一个 SELECT 就好. 象以下的,

SELECT * FROM VIEW1
WHERE (mydate BETWEEN '2006-07-01' AND '2006-07-10')