您所在位置：主题：求一带条件的存储过程
yxpke
[专家分：100] 发布于 2007-12-31 18:06:00
if studentnum<>'' then'
select * from mytable where studentnum like 'studentnum%'
elseif name<>'' then
select * from mytable where name like 'name%'
elseif nj_c<>'' then
select * from mytable where nj_c='nj_c'
end if
在存储过程应如何写，请高手帮忙
select * from mytable where studentnum like 'studentnum%'
elseif name<>'' then
select * from mytable where name like 'name%'
elseif nj_c<>'' then
select * from mytable where nj_c='nj_c'
end if
在存储过程应如何写，请高手帮忙