Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

trigger Expand / Collapse
Author
Message
Posted Tuesday, June 15, 2010 7:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 16, 2010 12:03 AM
Points: 2, Visits: 2
Hi
I am Havin two tables Metric and UpdatedMetric
if any of field from Metric table is updated then a column value must be set in UpdatedMetric Table
I want to use trigger only
plz reply
Post #937490
Posted Tuesday, June 15, 2010 8:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 14,326, Visits: 37,418
will you be providing any details? For any meaningful answer we need the CREATE TABLE definitions of both tables, and which "value" (column) triggers some change to be propigated to the other table

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #937534
Posted Wednesday, June 16, 2010 12:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 16, 2010 12:03 AM
Points: 2, Visits: 2
all data is being saved from a grid In My metric table .
I just want to check that if a given row is updated In metric table then a trigger must be fired for the updated row and accordingly in my UpdatedMetric table i have taken a cloumn in that '1' value must be set for that cloumn.for the updated row in metric table.
Post #937941
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse