SQL trigger, rollback , update, limits

brucenx · December 15th, 2004, 05:16 AM

Hi,
How can I update a table's OTHER columns while using rollback or raiserror to show that one specific column can't be changed?
eg;
in student table, I just want to update/delete/insert the student's FamilyName, and LastName, If update his StudentID, a trigger rollback will active and StudentID wont be updated while FamilyName and LastName have been changed.??

thanks

jemacc · December 17th, 2004, 07:05 AM

You could try and query the inserted and delete for what you want and use something like this and also can be use for update

Code:

Create table Test
(something char(1))
go
CREATE TRIGGER DeleteTrigger
ON Test
FOR DELETE
AS 
BEGIN

     Select * from deleted where something = 'A'
     if @@rowcount <> 0
          ROLLBACK TRAN
END

go

insert Test values ('A')
insert Test values ('B')
select * from Test

delete from Test where something = 'A'
select * from Test
delete from Test where something = 'B'
select * from Test

Jaime E. Maccou