Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Nov 09, 2006 07:22 PM|LINK
( so the stored procedure can compare the timestamp with the same data record's current time stamp)
You cannot compare timestamp unless you know the value before the insert and timestamp is both binary for not null and varbinary for null, I am assuming there is an algebraic reason for this variation. Now what you want to do is best handled with a trigger
and it is covered in the thread below with code to get you started. Hope this helps.