'@option'附近的语法不正确. [英] Incorrect syntax near '@option'.

问题描述

任何人都可以纠正以下错误:


错误:

Can Anyone Rectify below Error:


Error:

Incorrect syntax near ''@option''.

错误过程:

Error procedure:

create procedure pro(@pro_id varchar(50),@pro_name varchar(50),@description varchar(50),@priority int,@pro_img varchar(50),@search_img1 varchar(50),@search_img2 varchar(50),@search_img3 varchar(50),@search_img4 varchar(50),@search_img5 varchar(50),@keyword1 varchar(50),@keyword2 varchar(50),@keyword3 varchar(50),@keyword4 varchar(50),@keyword5 varchar(50),@y_url varchar(50),@type varchar(50),@price float)
@option varchar(50)///Error
AS
BEGIN
if @option='Submit'// Error
begin
insert into product(pro_id,pro_name,description,priority,pro_img,search_img1,search_img2,search_img3,search_img4,search_img5,keyword1,keyword2,keyword3,keyword4,keyword5,y_url,type,price) values(@pro_id,@pro_name,@description,@priority,@pro_img,@search_img1,@search_img2,@search_img3,@search_img4,@search_img5,@keyword1,@keyword2,@keyword3,@keyword4,@keyword5,@y_url,@type,@price)
end
else if @option='Update'//Error
begin
update product set(pro_id=@pro_id,pro_name=@pro_name,description=@description,priority=@priority,pro_img=@pro_img,search_img1=@search_img1,search_img2=@search_img2,search_img3=@search_img3,search_img4=@search_img4,search_img5=@search_img5,keyword1=@keyword1,keyword2=@keyword2,keyword3=@keyword3,keyword4=@keyword4,keyword5=@keyword5,y_url=@y_url,type=@type,price=@price)
end
END

推荐答案

如果@Option应该是参数，则移动右括号:

If @Option should be a parameter then move the closing parenthesis:

create procedure pro(@pro_id varchar(50),@pro_name varchar(50),@description varchar(50),@priority int,@pro_img varchar(50),@search_img1 varchar(50),@search_img2 varchar(50),@search_img3 varchar(50),@search_img4 varchar(50),@search_img5 varchar(50),@keyword1 varchar(50),@keyword2 varchar(50),@keyword3 varchar(50),@keyword4 varchar(50),@keyword5 varchar(50),@y_url varchar(50),@type varchar(50),@price float, @option varchar(50))
AS

这篇关于'@option'附近的语法不正确.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！