如何在sqlserver中写触发器

Question

两张表，不同的字段名，字段个数不同，且两张表没有任何的关联。请问各位大神要怎样‘
写啊 ，非常急！！！

Answer 1

给你个例子：

USE [guagua_money]
GO
/****** Object: Trigger [dbo].[bankMoneyRecord] Script Date: 11/19/2015 16:47:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[bankMoneyRecord]
ON [guagua_money].[dbo].[t_user_money_bank]
for insert,update
AS
if update(money)
BEGIN
SET NOCOUNT ON;

-- 变量声明
DECLARE @user_id bigint;    -- 用户ID
DECLARE @before_money money;    -- 修改之前的钱数
DECLARE @after_money money; -- 修改之后的钱数
DECLARE @create_time varchar(50);   -- 创建时间

set @user_id = (select user_id from Inserted);
set @before_money = (select money from Deleted);
set @after_money = (select money from Inserted);
set @create_time = (convert(varchar(20),getdate(),120));

insert into [guagua_money].[dbo].[t_user_money_bank_modify_detail] (user_id, before_money, after_money, create_time)
values (@user_id, @before_money, @after_money,@create_time);

END