[MS SQL] SQL 效能改善 - 不要在where用function

捞很久居然是因为在变数里用funtion

select *from CUST t2 with (nolock) and BirthDate between dbo.YYYYMMDDtoCYMMDD (convert(varchar, getdate(), 112))-5 and dbo.YYYYMMDDtoCYMMDD (convert(varchar, getdate(), 112))

#这样就解决了

declare @msDate int declare @meDate int set @msDate = dbo.YYYYMMDDtoCYMMDD (convert(varchar, getdate(), 112))-5set @meDate = dbo.YYYYMMDDtoCYMMDD (convert(varchar, getdate(), 112))select * from CUST t2 with (nolock) where BirthDate between  @msDate and  @meDate 

如果上面的方式还是不行,可以再试试用
EXEC('select ....')