存储过程往拼接的sql语句中传递日期值
1 declare @start datetime 2 declare @end datetime 3 set @start='2014-3-1' 4 set @end='2014-3-31' 5 declare @sql Nvarchar(4000) 6 set @sql=' 7 select * from search_record 8 where (Name!='' or Phone!='') 9 and (thedate between @st and @en )' 10 11 exec sp_executesql @sql,N'@st datetime,@en datetime',@start,@end