>>Hello all, first things first - I have never used triggers. In a lot of my sp's I create a record of the current values of a table that I'm about to update along with the new values for the table - this makes it very easy for me to report on edits, is it possible to do this using a trigger ? A typical example of what I do is shown below
>>
>>
>>Proc UpdateAddress(@Addressid int,@line1 varchar(35),(@line2 varchar(35),
>>(@line3varchar(35),
>>(@line4 varchar(35))
>>As
>>Insert into AddressHistory
>>(Addressid int,
>>line1 ,
>>line2,
>>line3,
>>line4,
>>xline1,
>>xline2,
>>xline3,
>>xline4)
>>(Select
>>Addressid,
>>line1,
>>line2,
>>line3,
>>line4,
>>@line1,
>>@line2,
>>@line3,
>>@line4 from address where addressid = @Addressid )
>>
>>
>>
>>
>>
>>
>
>Check this related thread
http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/5c4778d5-2519-480b-abd0-93b9a90a587dThanks for that but I think I'll go the trigger route
Regards,
Peter J. Kane
Pete