hi to all,
i want get the updated records using the trigger. i am using the following query for that,


create trigger updatetrigger ON testtable for UPDATE AS BEGIN Declare @Name nvarchar(50)
Declare @age nvarchar(50)
Declare @mailid nvarchar(50)
Declare @phoenno nvarchar(50)
Declare @datetime smalldatetime SELECT @Name = Name , @age = age , @mailid = mailid , @phoenno = phoenno , @datetime = datetime FROM INSERTED
END


my table testtable does not contain unique field.

when i update the value in the testtable. the affected row is not stored in the testtable1. how can i solve the probems. plz help me . and also i need to get the records before updated . can i get the records using the update triggers. if anybody know plz help me.


thank u

with thanks and regards
mmary