27,579
社区成员
发帖
与我相关
我的任务
分享
alert view V as
select * FROM e WITH ( NOLOCK )
WHERE e.LastUpdateDateTime > ( SELECT [LastUpdateTime]
FROM f WHERE PC='IP'
)
where E,Last>(select lastupdate form F )
这种写法本身就不好。我已经建议开发人员,该为存储过程:
Declare @DT =select lastupdate form F where PC='IP'
where E,Last>@DT
ALTER VIEW V AS
WITH t AS (
SELECT TOP 1 [LastUpdateTime]
FROM f
WHERE PC = 'IP'
)
SELECT *
FROM e WITH (NOLOCK)
WHERE e.LastUpdateDateTime > (
SELECT [LastUpdateTime]
FROM t
)
看下这样是否能提高