这段代码有什么错误 [英] 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屋！