SQL script to undeploy rules/vocabularies
来源:互联网 发布:混凝土计算软件 编辑:程序博客网 时间:2024/06/01 08:36
USE [BizTalkRuleEngineDb]
GO
/****** Object: StoredProcedure [dbo].[usp_un_rule] Script Date: 04/27/2009 22:34:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[usp_un_rule]
(
@rulesetName varchar(255),
@verMajor int,
@verMinor int
)
As
Begin
DECLARE @RuleSetID int
SELECT @RuleSetID = nRuleSetID
FROM RE_Ruleset
WHERE strName=@rulesetName AND nMajor=@verMajor AND nMinor=@verMinor
UPDATE RE_Ruleset
SET nStatus = 0 WHERE nRuleSetID = @RuleSetID
DELETE FROM re_deployment_config WHERE nRuleSetID = @RuleSetID
DELETE FROM re_tracking_ID WHERE nRuleSetID = @RuleSetID
End
GO
/****** Object: StoredProcedure [dbo].[usp_un_voc] Script Date: 04/27/2009 22:34:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[usp_un_voc]
(
@vocName varchar(255),
@verMajor int,
@verMinor int
)
As
Begin
DECLARE @nVocabularyID int
SELECT @nVocabularyID = nVocabularyID
FROM re_vocabulary
WHERE strName = @vocName AND nMajor=@verMajor AND nMinor=@verMinor
UPDATE re_vocabulary SET nStatus = 0 WHERE nVocabularyID = @nVocabularyID
End
- SQL script to undeploy rules/vocabularies
- SQL script to undeploy rules/vocabularies
- SQL script to undeploy rules/vocabularies
- SQL script to undeploy rules/vocabularies
- SQL Script to Release Hold
- SSW Rules to Better SQL Reporting Services 2005
- how to execute sql script in c#
- sql script
- sql script
- SQL Script
- Script to Collect RAC Diagnostic Information (racdiag.sql)
- Using SQLCMD to deploy sql script on SQLServer
- High SQL Version Counts - Script to determine reason(s)
- Quick to learn Python rules
- sql: postgreSQL sql script
- sql: postgreSQL sql script
- How to save SQL Server data as Insert INTO SQL Script
- SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
- 曾国藩给经理人的7堂课
- Delphi COM接口編程(ActiveX Library)(二)
- sql中的order by
- 联想ThinkPad SL、R、T三系列的区别希望能帮助大家
- About autoDiscover job hunted
- SQL script to undeploy rules/vocabularies
- 游戏.状态管理器
- SQL script to undeploy rules/vocabularies
- SQL script to undeploy rules/vocabularies
- WinCE下调用本地的.exe程序
- 9款网页绘图javascript框架
- 一个好用的日期时间类(c++)
- 表及字段描述信息处理示例
- oracle9i 和10g安装在同一系统下的TNS: 协议适配器错误的解决方法