Post reply

INSERT

  • June 30, 2008 at 4:08 pm

    #72472

    How can i insert into Blob field which contains 15mb of data for each row, without locking the table.

  • July 1, 2008 at 9:54 am

    #836788

    any help?

  • July 1, 2008 at 11:24 am

    #836840

    when i read in msdn it says

    READPAST, NOLOCK, and READUNCOMMITTED are not allowed

    but if i do this i get no error.

    INSERT INTO table (field)

    select field

    FROM table2 WITH (NOLOCK).

    is there any other way inserting a blob field without any locks on table.

  • July 2, 2008 at 2:01 pm

    #837482

    I didnt get nay reply for this..

    is this kind of weired question? guys let me know if have encountered such problem.

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

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