新表有什么栏位--UserID账号ID insert into H_Wealth(UserID) select UserID from H_User
插入表数据,新表同时插入,就需要在新表中,做一个触发器.只要[会员表]在INSERT INTO 动作时,就同时执行:insert into 在新表中。比如:CREATE TRIGGER [dbo].[test_Insert_Trigger] ON [H_Wealth]AFTER INSERT AS BEGIN SET NOCOUNT ON; insert into test_copy select * from inserted;END
insert into H_Wealth(UserID)
select UserID from H_User
AS
BEGIN
SET NOCOUNT ON;
insert into test_copy select * from inserted;END