Need help with a trigger please

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 2000 Forums

Transact-SQL (2000)

Need help with a trigger please

Author

Topic

koolbadge
Starting Member

2 Posts

Posted - 2006-09-14 : 10:40:03

Need help with a trigger please!

Table: tblSomeTable
Field: [status]

When [status] changes to "F", delete the row

Is this possible?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-09-14 : 10:46:23

Put this in your update trigger


delete d
from   inserted i inner join tblSomeTable d
       on  i.some_pk = d.some_pk
where  i.[status] = 'F'

koolbadge
Starting Member

2 Posts

Posted - 2006-09-14 : 11:12:33

Superb - thank you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources