Solved

Insert Update in multi-user database SQL Server

Posted on 2013-01-29
2
334 Views
Last Modified: 2013-05-29
Hi,

How to do inesert/update in multi-user database environment in sql server 2005/2008?
0
Comment
Question by:ezkhan
2 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 38830840
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
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38830945
Or you use MERGE and side-step the need to do explicit BEGIN TRANSACTION ... ROLLBACK ... COMMIT
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question