Jump to content

SQL - Update and Timestamp

NewsBot
 Share

Recommended Posts

NewsBot Newbie

NewsBot

Posted
Posted

I'm currently working on a project with a database and have to keep in account that concurrency problems might occur.

So I'm using*a timestamp column in most/all of the tables. My question is: what's the best sql stored procedure when updating data? Obviously I should compare the timestamp and see if it matches the last time it was read. But other than that, do I have to use transactions, raise exception, just return a -1 value if the timestamps don't match?

 

What's the best stored procedure?

 

More...

 

View All Our Microsoft Related Feeds

View All Our Microsft Related Feeds
  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...