--使用缓存 exec sp_executesql N'select * from consume where DATE = @t', N'@t DateTime', '2018-12-04 00:00:00.000'