sql中如何设置存储过程的默认值为当前日期

存储过程参数的默认值只允许常量和null. 可以做如下修改：create proc proc_borrow@willdate datetime=null,@retumdate datetime=nullasselect * from Borrow where WillDate between isnull(@willdate,dateadd(yy,-1,GETDATE())) and isnull(@retumdate,GETDATE())go