34,590
社区成员
发帖
与我相关
我的任务
分享
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[infotrans]
@cp VARCHAR(20),
@cd VARCHAR(20)
AS
BEGIN
IF 1=ISNUMERIC(@cp)
INSERT INTO temp1(cperson_id) VALUES(@cp)
ELSE
PRINT 'invalid input value:'+CONVERT(VARCHAR(20),@cp)
RETURN
IF 1=ISNUMERIC(@cd)
UPDATE temp1 SET cdept_id=@cd WHERE cperson_id=@cp
ELSE
PRINT 'invalid input value:'+CONVERT(VARCHAR(20),@cd)
RETURN
END
--楼主啊,你想如果不是数字就返回,不在继续执行,你得家begin end,酱紫嘛
IF 1=ISNUMERIC(@cp)
INSERT INTO temp1(cperson_id) VALUES(@cp)
ELSE
begin
PRINT 'invalid input value:'+CONVERT(VARCHAR(20),@cp)
RETURN
end
IF 1=ISNUMERIC(@cd)
UPDATE temp1 SET cdept_id=@cd WHERE cperson_id=@cp
ELSE
Begin
PRINT 'invalid input value:'+CONVERT(VARCHAR(20),@cd)
RETURN
End
ALTER PROC [dbo].[infotrans]
@cp VARCHAR(20),
@cd VARCHAR(20)
AS
BEGIN
--1.
IF 1=ISNUMERIC(@cp)
INSERT INTO temp1(cperson_id) VALUES(@cp)
ELSE
PRINT 'invalid input value:'+CONVERT(VARCHAR(20),@cp)
--2.
IF 1=ISNUMERIC(@cd)
UPDATE temp1 SET cdept_id=@cd WHERE cperson_id=@cp
ELSE
PRINT 'invalid input value:'+CONVERT(VARCHAR(20),@cd)
END
GO