为过程或函数 procedure_goods_insert 指定了过多的参数.create procedure procedure_goods_insert(@goods_id int,@goods_name varchar(20),@goods_guig varchar(50),@goods_unit varchar(6),@goods_txt text)asinsert into goods values(@goods_id,@good
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/23 18:38:41
为过程或函数 procedure_goods_insert 指定了过多的参数.create procedure procedure_goods_insert(@goods_id int,@goods_name varchar(20),@goods_guig varchar(50),@goods_unit varchar(6),@goods_txt text)asinsert into goods values(@goods_id,@good
为过程或函数 procedure_goods_insert 指定了过多的参数.
create procedure procedure_goods_insert
(@goods_id int,@goods_name varchar(20),@goods_guig varchar(50),@goods_unit varchar(6),@goods_txt text)
as
insert into goods values(@goods_id,@goods_name,@goods_guig,@goods_unit,@goods_txt)
go
测试语句:
declare @id int
exec procedure_goods_insert '200002','护肤春秋被','200*230','条','',@id output
然后就提示如题了 新手不知道哪里错了
最好能详细点
为过程或函数 procedure_goods_insert 指定了过多的参数.create procedure procedure_goods_insert(@goods_id int,@goods_name varchar(20),@goods_guig varchar(50),@goods_unit varchar(6),@goods_txt text)asinsert into goods values(@goods_id,@good
@id output 删除掉,不知道这个做什么的
procedure_goods_insert这个过程只要5个参数exec procedure_goods_insert('200002','护肤春秋被','200*230','条','')