trigger

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » trigger

trigger

Rate Topic

Display Mode

Topic Options

Author

Message

bhosale.vikram.s

Posted Tuesday, June 15, 2010 7:33 AM

Forum 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

Lowell

Posted Tuesday, June 15, 2010 8:09 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:59 PM
Points: 11,792, Visits: 28,078

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #937534

bhosale.vikram.s

Posted Wednesday, June 16, 2010 12:09 AM

Forum 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 »

Permissions