COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
create procedure CHECKUSER
RETURNS
( RESULT1 SMALLINT)
AS BEGIN EXIT; END
^ALTER PROCEDURE CHECKUSER
RETURNS
( RESULT1 SMALLINT)
AS
BEGIN
FOR SELECT COUNT(*) FROM USERLOGIN
INTO :RESULT1;
END
^SET TERM ^ ;
SET AUTODDL ON;
COMMIT WORK;我试了好几次,都是建立了存储过程但是不能更改,不知道哪里错了我用的7。0
SET AUTODDL OFF;
SET TERM ^ ;
create procedure CHECKUSER
RETURNS
( RESULT1 SMALLINT)
AS BEGIN EXIT; END
^ALTER PROCEDURE CHECKUSER
RETURNS
( RESULT1 SMALLINT)
AS
BEGIN
FOR SELECT COUNT(*) FROM USERLOGIN
INTO :RESULT1;
END
^SET TERM ^ ;
SET AUTODDL ON;
COMMIT WORK;我试了好几次,都是建立了存储过程但是不能更改,不知道哪里错了我用的7。0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货