Click here to Skip to main content
15,741,407 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
how to get inserted values of inserted data from another table.
for example -
There are two table A,B.
insert data in A from C# page and then trigger of A is insert data in B then how to get identity row of B.

See this : Triggers-Sql Server[^] Its not that hard.
Share this answer
As you haven't indicate how you want to use this. I can suggest 2 different techniques that you explore for your solution.

1. Triggers[^]
There are some examples at the bottom of the page.

2. Ouput clause[^] - assuming that you are using SQL 2005 or later.

Again there are some examples at the bottom of the page.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900