SQL Server Performance Forum – Threads Archive

Create Trigger

Hey,
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,
Mattie

Check this out:
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=59&rl=1 Also, check SQL Server Books Online for create trigger. Thanks, Name
———
Dilli Grg (1 row(s) affected)

Thank you so much.
Mattie

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] <pre id="code"> Thanks, Name ——— Dilli Grg (1 row(s) affected) </pre id="code">

]]>