Click here to Skip to main content
15,905,593 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am facing a issue like if my table is like
DATABASE NAME:DB2
ID Name Price Date

1 mango 12 2/2/2012
2 banana 31 1/2/2012
3 fruit 100 3/1/2012

if i try to alter the content(DML OPERATION) of the current table where a trigger must occur and in my other database it should save as WHERE i am trying the alter the price column

DATABASE NAME:DB3

ID Price Date

1 12 2/2/2012
2 31 1/2/2012
3 100 3/1/2012

thanks in advance
Posted

1 solution

You need to use inserted and deleted tables. Find out more about them at Using the inserted and deleted Tables[^].
 
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