ahmed elbarbary

ahmed elbarbary

  • 959
  • 1.6k
  • 149.1k

How to allow multi user work on same table without any issue of intera

Jan 8 2022 9:40 AM

I work on sql server 2017 I have issue
How to allow mutli user working on same table without using temp table
and without interact two user with same data
as example

user a :


exec sp_workingmultiuser 5


user b :

exec sp_workingmultiuser 10

create proc sp_workingmultiuser
@productid int

select * into dbo.testtrade from parts.tradecodes
where productid=@productid


so my question if
user a
using product id 5
user b
using product id 10 on same time

data for user b will display for user a

so how to prevent that please ?

Answers (3)