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
as
begin

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

end

so my question if
user a
using product id 5
and
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)