How To Insert Same Record In Two Table Simultaneously In SQL Server

CREATE TRIGGER trigger_insertrecordtbl ON Agentname
FOR INSERT AS
DECLARE

@AgentName nvarchar(50),
@TeamName nvarchar(50),
@Status nvarchar(50)

;

SELECT @AgentName=(AgentName) FROM INSERTED
SELECT @Teamname=(Teamname) FROM INSERTED
SELECT @Status=(Status) FROM INSERTED

INSERT INTO
Agentname_Temp
(Agentname,Teamname,Status)
VALUES
(
@Agentname,@Teamname,@Status
)

insert into agentname (Agentname,Teamname,Status)
values
('Vandana','Ruby','Active')

select * from agentname_temp

/////////////////////// Create One Table structure

CREATE TABLE [dbo].[Agentname](
[id] [int] IDENTITY(1,1) NOT NULL,
[Agentname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Teamname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_Agentname] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

/////////////////////// Create another Table structure

CREATE TABLE [dbo].[Agentname_Temp](
[id] [int] IDENTITY(1,1) NOT NULL,
[Agentname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Teamname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_Agentname] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]