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