Create Trigger | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Create Trigger

I need your help please. I havent done Triggers much.
I need to write CREate trigger for after insert ,Update.
Lets say i have table A with Col1 , col2 , col3 and col4 if there is a new row inserted in table A then i need to have a trigger to insert this new row in Table B if a data gets updated in table A for col3
then i need a new row to be inserted in Table B Thank you,

Check this out: Also, check SQL Server Books Online for create trigger. Thanks, Name
Dilli Grg (1 row(s) affected)
Thank you so much.
[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />Thanks,<br /><br />Name<br />——— <br />Dilli Grg <br /><br />(1 row(s) affected)<br /></font id="code"></pre id="code">