打个比喻
create proc test
(
@timeone datetime,
@timetwo datetime
)
as
select *
from Display_Acc_View
where Rectime between @timeone and @timetwo如果我想设定@timeone 与@timetwo的默认值 就是我执行test时候不输入日期 它也按照默认的参数执行 怎么设定
create proc test
(
@timeone datetime,
@timetwo datetime
)
as
select *
from Display_Acc_View
where Rectime between @timeone and @timetwo如果我想设定@timeone 与@timetwo的默认值 就是我执行test时候不输入日期 它也按照默认的参数执行 怎么设定
http://topic.csdn.net/u/20090412/00/276f350e-afe0-4dcf-963b-9a1d10c112f7.html