Insert Image into MS SQČ 2000 not 2005

  • Hi, I have tried inserted Image with type .bmp to SQL 2000 into field with type image.

    but with

    INSERT INTO BLOBTest

    (name, iamge)

    SELECT 'First test file',

    BulkColumn FROM OPENROWSET(

    Bulk 'D:\gucek.bmp', image) AS image

    doesn`t work.

    probably in sql2005 this work

  • Anyone?

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

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