hi
Is there a way to determine

the original value and the current value of a field within an update
trigger?



thanks in advance,

Nir.

To echo CBretana explanation, here is an example for you.

HTH, Thanks

set nocount on
go

create table t(col int)
go

insert t values(1)
insert t values(2)
insert t values(3)
insert t values(4)
go

select * from t
go

create trigger tt on t
for update
as
declare @i int
select @i=col from inserted
print 'new value'
print @i

select @i=col from deleted
print 'old value'
print @i

go


update t set col=44 where col=4
go

select * from t
go

drop trigger tt
drop table t
go



--
http://zulfiqar.typepad.com
MCP


[quoted text, click to view]