Solved

Insert Update in multi-user database SQL Server

Posted on 2013-01-29
2
312 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 69

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now