TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
How To Insert Same Record In Two Table Simultaneously In SQL Server
Vandana
Aug 20
2016
Code
716
0
1
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
expand
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
]
Insert Same Record
Two Table Simultaneously
SQL Server