在存储过程中有问题
问题描述：
你好朋友
以下是我的存储过程.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