Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » if Updated my table i want change status
Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 10:25 AM
Points: 20, Visits: 178
Hi,
I was updated my table ,then i want change status_flg in updated table
is it possiable ?

help me ,,

Regards
Arjun
Post #1412751
Stupeo
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: Thursday, February 07, 2013 3:07 AM
Points: 890, Visits: 774
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.