存储过程往拼接的sql语句中传递日期值

存储过程往拼接的sql语句中传递日期值

  declare @start datetime

    declare @end datetime

    set @start='2014-3-1'

     set @end='2014-3-31'

      declare @sql Nvarchar(4000)

      set @sql='

     select * from search_record

                         where (Name!='' or Phone!='')

           and (thedate between @st  and @en  )'

 exec sp_executesql @sql,N'@st datetime,@en datetime',@start,@end