Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 mark a record as updated

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2009-06-02 : 07:28:41
is there an easy way I can a field in a table (bit) to automatically be =1 when a record is updated?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-02 : 07:40:13
You can install a trigger to do this for you.
Otherwise I don't know about anything that could do it automatically.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -