Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem with trigger Expand / Collapse
Author
Message
Posted Wednesday, April 24, 2013 7:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 25, 2013 8:55 AM
Points: 1, Visits: 6
Hi Everyone,

I have a problem with triggers. Trigger must be fired and update COLUMN_A in TABLE2 after insert COLUMN_B in TABLE 1 . Have anyone some idea ? I'm new in SQL Server and don't know much...
Post #1446269
Posted Thursday, April 25, 2013 6:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:25 AM
Points: 2,660, Visits: 4,733
sd_xxx_sd (4/24/2013)
Hi Everyone,

I have a problem with triggers. Trigger must be fired and update COLUMN_A in TABLE2 after insert COLUMN_B in TABLE 1 . Have anyone some idea ? I'm new in SQL Server and don't know much...


What is the problem here?

You will have to create a trigger in TABLE 1, and do some programming to update the column COLUMN_A in TABLE2.



Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1446461
Posted Thursday, April 25, 2013 8:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:06 PM
Points: 12,994, Visits: 12,411
We can't really offer a lot of help here because you haven't offered many details.

This is a good place to get started.
http://msdn.microsoft.com/en-us/library/ms189799.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1446515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse