( 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.
Caddre
All-Star
26581 Points
5308 Posts
Re: SQL Timestamp and ASP.NET
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.
http://forums.asp.net/thread/1450952.aspx
Gift Peddie