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

if Updated my table i want change status Expand / Collapse
Author
Message
Posted Monday, January 28, 2013 10:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 4, 2013 9:41 AM
Points: 20, Visits: 201
Hi,
I was updated my table ,then i want change status_flg in updated table
is it possiable ?

help me ,,

Regards
Arjun
Post #1412751
Posted Tuesday, January 29, 2013 12:57 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 13, 2014 11:32 AM
Points: 939, Visits: 778
What you need is a TRIGGER:

http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx

If you post your table schema, I will put together a sample trigger for you.

Matt
Post #1412792
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse