34,590
社区成员
发帖
与我相关
我的任务
分享
update a set b=(case when c=1 then 1 else 0 end)
CREATE TRIGGER [dbo].[wdzh_update]
ON [dbo].[wdzh]
AFTER UPDATE
AS
DECLARE @catid SMALLINT; /** 从属应用id **/
DECLARE @tid BIGINT; /** 应用内的表的唯一id **/
DECLARE @zhzt SMALLINT;
DECLARE @zhpage SMALLINT;
SELECT @catid = wdzh_cat,
@tid = wdzh_reid,
@zhzt = wdzh_state,
@zhpage = wdzh_pages
FROM inserted;
IF @catid = 1
BEGIN
/** 平台1 **/
UPDATE pt1.dbo.wdgl
SET wdgl_pages = @zhpage,
wdgl_zhzt = @zhzt
WHERE wdgl_id = @tid;
END;
IF @catid = 2
BEGIN
UPDATE pt2.dbo.wdgl
SET wdgl_pages = @zhpage,
wdgl_zhzt = @zhzt
WHERE wdgl_id = @tid;
END;