Hi,

What would be the best option to use between the RowVersion and TimeStamp for checking the concurrency type and why?

Edhy Rijo

One other point here....if you actually wanted to include the concurrency field in any type of query, you are dealing with, as you said, binary data.  This becomes more difficult to include in queries if you are trying to determine something in regards to auditing, etc.  So if you were trying to filter out records to see only records that have been modified, then you would have to create a query using values like this:

(Which obviously you would want to use a parm, but you get my point)

Versus using an integer value

So anyway that I look at it...it is far easier to deal with an integer...at least in my simple world