--把你的过程改了下,看看对不对,code作为主键 CREATE PROCEDURE add_sch @code int, @name varchar(10), @addr varchar(50), @note varchar(50), @flag varchar(1), AS declare @result int if not exists(select 1 from schools where code=@code) begin insert into schools(sch_code,sch_name,sch_addr,sch_note,flag) values(@code,@name,@addr,@note,@flag) set @result=1 end else begin set @result=0 end return @result GO
报错“List index out of bounds(3)”to:wzh1215 语法出错,在AS附近
to:wzh1215(四脚蛇) 改了一下用你的这段语法检查通过了。可是仍然不能二次添加记录。各位高手老师们:报错“List index out of bounds(3)”是什么原因啊???
--把你的过程改了下,看看对不对,code作为主键
CREATE PROCEDURE add_sch
@code int,
@name varchar(10),
@addr varchar(50),
@note varchar(50),
@flag varchar(1),
AS
declare @result int
if not exists(select 1 from schools where code=@code)
begin
insert into schools(sch_code,sch_name,sch_addr,sch_note,flag)
values(@code,@name,@addr,@note,@flag)
set @result=1
end
else
begin
set @result=0
end
return @result
GO
语法出错,在AS附近
改了一下用你的这段语法检查通过了。可是仍然不能二次添加记录。各位高手老师们:报错“List index out of bounds(3)”是什么原因啊???