解决sql server中批处理过程中“'CREATE/ALTER PROCEDURE 必须是查询批次中的第一个语句”

来源：互联网发布：淘宝模特编辑：程序博客网时间：2024/05/14 04:35
-----------------------------------------line-------------------------------------------------USE [p20-cy-2966];/*   V1.0.2版本SQL批处理*/--判断某表的某字段是否存在if (not exists(select * from syscolumns where id=object_id('BlanceManageO2O') and name='OrderInfoNum'))ALTER TABLE BlanceManageO2O ADD OrderInfoNum INT DEFAULT 0;GO--判断某存储过程是否存在if (exists (select * from sys.objects where name = 'sp_BlanceOrderInsertCatering'))    drop proc sp_BlanceOrderInsertCateringGOCREATE PROCEDURE [dbo].[sp_BlanceOrderInsertCatering] -- 由存储过程SettlementManageO2O 中传入值@ShopId int,@AgentId int,@BlanceId int,    @IndustryId int,  --行业类型 行业Id 1-零售 2-餐饮 3-酒店 4-娱乐 5-家政 6-旅游 7-二手@Yearint,                                    --年@Month  int,                                    --月@Dayint,                                       --日@O2OShopPercent decimal(18,2),                      --020提成百分比@WeixinPoundaga decimal(18,2),                      -- 获取系统设置PlatBaseSet表中的微信支付手续费百分比  @TransferPriceSum     decimal(18,2) output   ASBEGIN--处理程序ENDGO--判断某存储过程是否存在if (exists (select * from sys.objects where name = 'SettlementManageCatering'))    drop proc SettlementManageCateringGOCREATE PROCEDURE [dbo].[SettlementManageCatering]ASBEGIN   --处理程序ENDGO-----------------------------------------line-------------------------------------------------USE [p20-cy-2967];/*   V1.0.2版本SQL批处理*/--判断某表的某字段是否存在if (not exists(select * from syscolumns where id=object_id('BlanceManageO2O') and name='OrderInfoNum'))ALTER TABLE BlanceManageO2O ADD OrderInfoNum INT DEFAULT 0;GO--判断某存储过程是否存在if (exists (select * from sys.objects where name = 'sp_BlanceOrderInsertCatering'))    drop proc sp_BlanceOrderInsertCateringGOCREATE PROCEDURE [dbo].[sp_BlanceOrderInsertCatering] -- 由存储过程SettlementManageO2O 中传入值@ShopId int,@AgentId int,@BlanceId int,    @IndustryId int,  --行业类型 行业Id 1-零售 2-餐饮 3-酒店 4-娱乐 5-家政 6-旅游 7-二手@Yearint,                                    --年@Month  int,                                    --月@Dayint,                                       --日@O2OShopPercent decimal(18,2),                      --020提成百分比@WeixinPoundaga decimal(18,2),                      -- 获取系统设置PlatBaseSet表中的微信支付手续费百分比  @TransferPriceSum     decimal(18,2) output   ASBEGIN--处理程序ENDGOif (exists (select * from sys.objects where name = 'SettlementManageCatering'))    drop proc SettlementManageCateringGOCREATE PROCEDURE [dbo].[SettlementManageCatering]ASBEGIN   --处理程序ENDGO
阅读全文
0 0