• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Insert Update in multi-user database SQL Server


How to do inesert/update in multi-user database environment in sql server 2005/2008?
1 Solution
Éric MoreauSenior .Net ConsultantCommented:
what is your concern?

you do it exactly like in a single user database. the only exception is that if you are using explicit transactions, make sure you commit them quickly
Anthony PerkinsCommented:
Or you use MERGE and side-step the need to do explicit BEGIN TRANSACTION ... ROLLBACK ... COMMIT
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now