For Programmers: Free Programming Magazines  


Home > Archive > ASP > October 2006 > Trigger









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Trigger
Mangler

2006-10-30, 6:59 pm

Need some help/advise.

I need 2 colums of one table to equal the value of 2 columns on another
table any time data is inserted there. Never messed with a trigger
before so I'm want to get help so I dont screw something up.

table - dbo.lotinfo

column - idrma
column - idlot

table - dbo.lotbd

column - idrma
column - idlot

anytime lotinfo has data inserted in the above columns I need the
respective columns in lotbd to equal the same thing automatically.

Any professional advise out there for a begginer with this subject??

Mangler

2006-10-30, 6:59 pm

please ignore this, I posted in the wrong place. I apologize

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com