这段代码有什么错误 [英] What is the mistake in this code
本文介绍了这段代码有什么错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
CREATE PROCEDURE sp_ResourceInsUpdDel (
@ResourceId int,
@Resource_Name varchar(50),
@Choice int)
AS
BEGIN
if(@Choice = 0)
insert into ResourceDetails values(@Resource_Name)
else if(@Choice =1)
update ResourceDetails set Resource_Name=@Resource_Name where ResourceId=@ResourceId
else if(@Choice =2)
delete from ResourceDetails where ResourceId=@ResourceId
End
我收到错误
i am getting error
Msg 213, Level 16, State 1, Procedure sp_ResourceInsUpdDel, Line 9
Insert Error: Column name or number of supplied values does not match table definition
请帮助我
please help me
推荐答案
尝试以下代码...
您的插入语句不正确..
try below code...
your insert statement was incorrect..
CREATE PROCEDURE sp_ResourceInsUpdDel (
@ResourceId int,
@Resource_Name varchar(50),
@Choice int)
AS
BEGIN
if(@Choice = 0)
insert into ResourceDetails(Resource_Name) values(@Resource_Name)
else if(@Choice =1)
update ResourceDetails set Resource_Name=@Resource_Name where ResourceId=@ResourceId
else if(@Choice =2)
delete from ResourceDetails where ResourceId=@ResourceId
End
这篇关于这段代码有什么错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文