How Can We Help?
I have 2 tables:
CREATE TABLE [dbo].[capalogin]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Username] [VARCHAR](50) NULL, [PcName] [VARCHAR](50) NULL, [lastlogin] [DATETIME] NOT NULL, CONSTRAINT [PK_capalogin_history] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[capalogin_history]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Username] [VARCHAR](50) NULL, [PcName] [VARCHAR](50) NULL, [lastlogin] [DATETIME] NOT NULL, CONSTRAINT [PK_capalogin_history] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
I want to be able to copy data when ever something is inserted or updated into the history table
CREATE TRIGGER saveToHistoryAfterInsert
ON [dbo].[capalogin]
for INSERT
AS
begin
INSERT INTO dbo.capalogin_history
( Username, PcName, lastlogin )
SELECT UserName, PcName, lastlogin FROM Inserted
end
GO
CREATE TRIGGER saveToHistoryAfterUpdate
ON [dbo].[capalogin]
for UPDATE
AS
begin
INSERT INTO dbo.capalogin_history
( Username, PcName, lastlogin )
SELECT UserName, PcName, lastlogin FROM Updated
end
GO