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.
| Author |
Topic |
|
GenerationWithoutName
Starting Member
26 Posts |
 Posted - 2002-07-19 : 03:00:19
|
| I have Table like this :CREATE TABLE tblTrans( TransID Int, IsActive Char(1) Default('0'), Constraint PK_tblTrans Primary Key (TransID))Example data ...:TransID IsActive1 '1'2 '0'3 '1'suppose someone delete data from tblTrans Where TransID=1Can I Cancel delete action Inside DELETE TRIGGER only if tblTrans.IsActive='1'DIJE |
|
|
dsdeming
479 Posts |
Posted - 2002-07-19 : 07:53:10
|
| Yes, you can. You just need to check the IsActive column of the deleted table. |
 |
|
|
|
|
|
TRIGGER DELETE