Can two user access single table in SQL?

Question

Can two user access single table in SQL?

rocky_498

SSCertifiable

Points: 6532
More actions
April 26, 2012 at 11:07 am

#260419

Hi guys,
I know its simple question and i can google it but i would like to know your though about,
Can two user access single table in SQL? (Same Database,Same Table)
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

It depends. What do you mean by access? The purpose of a database to facilitate multiple user access while maintaining the integrity of the data.

rocky_498 SSCertifiable Points: 6532 More actions · Answer 2

Thanks for Prompt reply!

I mean lets say i am using bunch of Select Statement on Employee Table & at the same time other user trying to insert or delete on same table (Employee) table.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Lynn Pettis

SSC Guru

Points: 442467

April 26, 2012 at 11:41 am

#1479944

I have to ask, what is the point of this question?

rocky_498 SSCertifiable Points: 6532 More actions · Answer 4

If i am understand right you are saying "what is the point of my Original Question?" Or you are asking my second reply?

Geoff A SSChampion Points: 11511 More actions · Answer 5

more than likely, Lynn is asking what is the point of your ORIGINAL question.

there are many variables to the question "Can 2 people access a table?"

the simple answer is "yes, they can"

the complicated answer is "maybe they can"

are there indexes? what is in the "where" clause of the select statement. what is in the where clause of the delete statement?

if your table is a heap, then many users can access the table, but expect some delays for locks to be released.....

rocky_498 SSCertifiable Points: 6532 More actions · Answer 6

Thanks for the Clarification Old Hand!

Thank you guys.