Hello all. I am looking for some help with setting up Optimistic Concurrency for my web application.

The App is written in ASP using SQL.

I really don't know where to begin, meaning:
- Is it set up in a connection script
- Can you assign it in the query
- How do you handle error codes (to avoid the page just erring out)

If someone would take the time to explian the basics of it, point me in the right direction to get some examples, or refer me to a post already explaining this I would really appreciate it.

Possibly Microsoft's own site can be the best description:

msdn.microsoft.com/library/en-us/ cpguide/html/cpconoptimisticconcurrency.asp