添加的存储过程

最新推荐文章于 2022-05-15 10:49:49 发布

buynider

最新推荐文章于 2022-05-15 10:49:49 发布

阅读量728

点赞数

分类专栏：学习文章标签：存储 manager

本文链接：https://blog.csdn.net/buynider/article/details/4775510

版权

学习专栏收录该内容

7 篇文章 0 订阅

订阅专栏

  Begin transaction --开始事务
if exists(select 1 from [BMDS_CustomerKindPlan] where [Year] = @Year and [Month] = @Month and [CustomerCode] = @CustomerCode)
begin
  raiserror('添加失败,该记录已存在',16,1)
  commit Transaction
  return
end
  INSERT INTO [BMDS_CustomerKindPlan](
  [PlanCode],[Year],[Month],[CustomerCode],[CreatedBy]
  )VALUES(
  @PlanCode,@Year,@Month,@CustomerCode,@CreatedBy
  )
IF @@ERROR!=0
  BEGIN
   Rollback Transaction
   select '0' as ifCanDo
  END
Else
  BEGIN
   commit Transaction
   select @@identity as ifCanDo
  END

存储过程

如果存在就修改，不存在就添加

if exists (select 1 from [BTS_ERP_DistributionOffice] WHERE [OfficeCode]=@OfficeCode)
  UPDATE [BTS_ERP_DistributionOffice] SET
  [OfficeName] = @OfficeName,[OfficeNameB] = @OfficeNameB,[CompanyType] = @CompanyType,[OilCategoryToSell] = @OilCategoryToSell,[OraganiseCode] = @OraganiseCode,[Manager] = @Manager,[Orderindex] = @Orderindex,[ModifiedDate] = GETDATE ()
  WHERE OfficeCode=@OfficeCode
else
  INSERT INTO [BTS_ERP_DistributionOffice](
  [OfficeCode],[OfficeName],[OfficeNameB],[CompanyType],[OilCategoryToSell],[OraganiseCode],[Manager],[Orderindex]
  )VALUES(
  @OfficeCode,@OfficeName,@OfficeNameB,@CompanyType,@OilCategoryToSell,@OraganiseCode,@Manager,@Orderindex
  )