Add Trigger

How Can We Help?

You are here:
< Back

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