CREATE TRIGGER INSERTA
ON [dbo].[Agents]
FOR INSERT
AS
DECLARE
@VAGENTID INT,
@VAGENTPASSWORD VARCHAR(50),
@VNTLOGIN VARCHAR(50),
@VQUEUE VARCHAR(50)
SELECT @VAGENTID = AGENTID, @VAGENTPASSWORD = AGENTPASSWORD,
@VNTLOGIN = NTLOGIN, @VQUEUE = QUEUE
FROM INSERTED
BEGIN
INSERT INTO [dbo].[genesys_agents_old] VALUES (@VAGENTID,@VAGENTPASSWORD,@VNTLOGIN,@VQUEUE);
END