给数据规范和内源名称自动加ID

--自动给内源加ID号
CREATE TRIGGER [dbo].[tabDIYTable_CFQ]
ON [dbo].[tabDIYTable]
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
--自动给内源加ID号
SET NOCOUNT ON;
UPDATE tabDIYTable SET tabName=tabName+CAST(tabID AS VARCHAR(50)) WHERE RIGHT(tabName,LEN(CAST(tabID AS VARCHAR(50))))<>CAST(tabID AS VARCHAR(50)) AND bBase=-1 AND tabID>1
END

--给数据规范加ID号
CREATE TRIGGER [dbo].[tabDataRule_CFQ]
ON [dbo].[tabDataRule]
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
--自动数据规范ID号
SET NOCOUNT ON;
UPDATE tabDataRule SET RuleName=RuleName+CAST(RuleID AS VARCHAR(50)) WHERE RIGHT(RuleName,LEN(CAST(RuleID AS VARCHAR(50))))<>CAST(RuleID AS VARCHAR(50)) AND RuleID>101 AND RuleID<800000000
END