Post reply

whether 2 "select" statements can cause Deadlock?

  • January 3, 2007 at 2:31 am

    #175433

    hi

    my query is

    whether 2 "select" statements can cause Deadlock?

     

    Thnks a lot for any help ..

     

     

  • January 3, 2007 at 3:16 am

    #680909

    essentially no, a deadlock has to involve a data change. 

    selects issue shared locks.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 3, 2007 at 3:42 am

    #680914

    unless its part of a transaction and the isolation level is appropriate or an updatelock or something has been issued.

  • January 3, 2007 at 3:48 am

    #680916

    selects don't work that way in a transaction and an updatelock isn't a select , selects can't give this behaviour.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 4 posts - 1 through 3 (of 3 total)

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