一个存储过程

最近在做一个系统，用到一些存储过程，有一个是这样的：

此存储过程根据输入的参数信息先确定要添加的绩效考核子项目所属的绩效考核是否存在，如果不存在，就先在表 tblPerformance 中添加一条绩效考核信息，然后再在表tblPerformItem 中添加要加入的绩效考核子项目。

 

  CREATE   PROCEDURE  spwebAddPerformObject
@EmpID   int ,
@PerformYear   int ,
@PerformSeason   int ,
@ObjectContent   nchar ( 100 ),
@rowcount   int  output

AS
declare   @P1   int , @P2   int
if   exists ( select  PerformID  from  tblPerformance  where  EmployeeID = @EmpID   and  PerformYear = @PerformYear  

and  PerformSeason = @PerformSeason )
begin  
set   @P1 = ( select  PerformID  from  tblPerformance  where  EmployeeID = @EmpID   and  PerformYear = @PerformYear   and  

PerformSeason = @PerformSeason )
insert   into  tblPerformItem(PerformID,ObjectContent)
values ( @P1 , @ObjectContent )
end
else
begin

insert   into  tblPerformance(EmployeeID,SubmitTime,PerformYear,PerformSeason)
values ( @EmpID , getdate (), @PerformYear , @PerformSeason )
set   @P2 = ( select  PerformID  from  tblPerformance  where  EmployeeID = @EmpID   and  PerformYear = @PerformYear   and  

PerformSeason = @PerformSeason )
insert   into  tblPerformItem(PerformID,ObjectContent)
values ( @P2 , @ObjectContent )
end
GO

 

对将查询结果赋值还不是很熟，所以现在只能写成这个样子了，待以后深入学习后优化一下，不过好歹可以用了，语法没有错误。