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.