独自幸福快乐吃东西把牙齿硌活动了依依不舍孤独

在列表C中，我创建了业务规则程序（例子中包含的程序是非常简单的；但是，在现实情况中，如果需要的话达到最佳抓地效果，它们可以很复杂）。所有的程序中包括了相同的输入参数；这是业务规则链接的一个小小的局限性。 列表B： INSERT INTO BusinessLogic(ProcessType, RunSequence, LogicProcedure)VALUES('CustomerOrders', 1, 'usp_Rule1')INSERT INTO BusinessLogic(ProcessType, RunSequence品牌：Cacharel, LogicProcedure)VALUES('CustomerOrders', 2, 'usp_Rule2')INSERT INTO BusinessLogic(ProcessType, RunSequence, LogicProcedure)VALUES('CustomerOrders', 3, 'usp_Rule3')INSERT INTO BusinessLogic(ProcessType, RunSequence, LogicProcedure)VALUES('CustomerOrders', 4, 'usp_Rule4')

列表C： CREATE PROCEDURE usp_Rule1 (@RunSequence TINYINT)AS PRINT 'In Procedure: ' + OBJECT_NAME(@@PROCID) PRINT 'Parameter Value Passed In:' + CAST(@RunSequenceAS VARCHAR(2))GOCREATE PROCEDURE usp_Rule2 (@RunSequence TINYINT)AS PRINT 'In Procedure: ' + OBJECT_NAME(@@PROCID) PRINT 'Parameter Value Passed In:' + CAST(@RunSequenceAS VARCHAR(2))GOCREATE PROCEDURE usp_Rule3 (@RunSequence TINYINT)AS PRINT 'In Procedure: ' + OBJECT_NAME(@@PROCID) PRINT 'Parameter Value Passed In:' + CAST(@RunSequenceAS VARCHAR(2))GOCREATE PROCEDURE usp_Rule4 (@RunSequence TINYINT)AS PRINT 'In Procedure: ' + OBJECT_NAME(@@PROCID) PRINT 'Parameter Value Passed In:' + CAST(@RunSequenceAS VARCHAR(2))GO