在存储过程中有问题 [英] proble in stored procedure

问题描述

你好朋友

以下是我的存储过程.set
中的语法错误是什么

Hi friends

The following is my stored procedure.what is the syntax error in set

ALTER procedure [dbo].[sp_insertregistrationnumber](@registrationnumber int,@classname varchar(30),@fromyear smallint,@toyear smallint,@datetime datetime,@adminid int)
as
begin
declare @classid int,@no int
if exists(select * from RegistrationNumbersetting_details where RegisterationNumber=@registrationnumber)
begin
update RegistrationNumbersetting_details set Fromyear=@fromyear,Toyear=@toyear,Updateddatetime=@datetime,adminid=@adminid where RegisterationNumber=@registrationnumber
end
else
begin
select @classid=Standered_id from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear
set @no=CONVERT(int,@registrationnumber+@classid)
insert into RegistrationNumbersetting_details(RegisterationNumber,ClassName,Fromyear,Toyear,Createddatetime,adminid)values(@no,@classname,@fromyear,@toyear,@datetime,@adminid)
end
end

预先感谢

Advance thanks

推荐答案

尝试一下
您错过了此行前面的右括号
"

try this
You have missed a closing bracket in front of this line
"

set @no=CONVERT(int,@registrationnumber+@classid)"

ALTER procedure [dbo].[sp_insertregistrationnumber](@registrationnumber int,@classname varchar(30),@fromyear smallint,@toyear smallint,@datetime datetime,@adminid int)
as
begin
declare @classid int,@no int
if exists(select * from RegistrationNumbersetting_details where RegisterationNumber=@registrationnumber)
begin
update RegistrationNumbersetting_details set Fromyear=@fromyear,Toyear=@toyear,Updateddatetime=@datetime,adminid=@adminid where RegisterationNumber=@registrationnumber
end
else
begin
select @classid=Standered_id from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)
set @no=CONVERT(int,@registrationnumber+@classid)
insert into RegistrationNumbersetting_details(RegisterationNumber,ClassName,Fromyear,Toyear,Createddatetime,adminid)values(@no,@classname,@fromyear,@toyear,@datetime,@adminid)
end
end

这篇关于在存储过程中有问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！