Post reply

SELECT rows that are not locked?

  • August 5, 2008 at 11:23 pm

    #382161

    I`m using this select to lock some rows:SELECT * FROM E2 WITH (UPDLOCK) WHERE A1=1

    1.) I want to list all rows from E2 that are not locked

    2.) How to clear the lock from the rows and then lock some other rows again.

    PLEASE HELP !

  • August 6, 2008 at 8:04 am

    #853831

    Why are you specifically locking the records? That's typically a bad idea unless you can't adress your issue in another manner. Why not put your records into a transaction if you need to lock them?

Viewing 2 posts - 1 through 1 (of 1 total)

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