关于存储过程语法的问题,答对了即刻给分。
caijf 2002-05-14 10:19:43 我写了如下一存储过程,但不知道错在什么地方,
create proc base_tj_destroy
@type int,@name char(20),@starttime datetime,@endtime datetime
as
case @type of
0: begin
select * from change
where (part='固定设备') and (destroy_date>=@starttime)
and (destroy_date<=@endtime)
end
1: begin
select * from change
where (part='固定设备')and(destroy_date>=@starttime)
and (destroy_date<=@endtime) and(usedept_num=@name)
end
2: begin
select * from change
where (part='固定设备')and(destroy_date>=@starttime)
and (destroy_date<=@endtime) and(borrow_people=@name)
end
end
不知道是不是在存储过程中不能用case语句,但我该用if语句来做判断,似乎也不行。请高手指点...