我给你SQL SERVER2000里的写法: CREATE PROCEDURE ABC_getValByID @sID int=0 AS declare @sTime datetimeselect @sTime=mactivetime from members where mid=@sID if dateadd(hour,24,@sTime)<getdate() begin select * from a end else begin select * from b endGO
谢谢楼上的朋友,你写的正是我想要的 可惜在mysql中不是这样写 哪位知道呢?
已解决: select mactivetime into stime from members where mid=sid 如果这个select是一个结果集的话就要用游标
delimiter // drop procedure if exists test // create procedure test(in par1 int) begin declare sTime datetime; select sTime=mactivetime from members where mid=par1; if hour(sTime)<24 then select * from a; else select * from b; end if; end //根据楼上的意思用MYSQL写了一下,通过了,但是不知道是不是你想要的结果
CREATE PROCEDURE ABC_getValByID
@sID int=0
AS
declare @sTime datetimeselect @sTime=mactivetime from members where mid=@sID
if dateadd(hour,24,@sTime)<getdate()
begin
select * from a
end
else
begin
select * from b
endGO
可惜在mysql中不是这样写
哪位知道呢?
select mactivetime into stime from members where mid=sid
如果这个select是一个结果集的话就要用游标
delimiter //
drop procedure if exists test //
create procedure test(in par1 int)
begin
declare sTime datetime;
select sTime=mactivetime from members where mid=par1;
if hour(sTime)<24 then
select * from a;
else
select * from b;
end if;
end //根据楼上的意思用MYSQL写了一下,通过了,但是不知道是不是你想要的结果
看看