inserting image in db table failes

Question

I have db table Person which has columns like

Id | Name | Dob | ....

now I added one more column CompanyLogo of type varbinary(MAX) which will is now null. Since I have more than 1000 records in Person table I want to insert on the fly using sql statement some default image for CompanyLogo. Later trough ui this image wil be changed for each person, but that's not the scope of this question.

I tried with code

@"begin
     UPDATE Person SET [CompanyLogo] = (SELECT
     CompanyLogo.* from Openrowset(Bulk
     'd:\test.png', Single_Blob) TestCompanyLogo)                    
    end
  "

but I'm getting following exception

System.Data.SqlClient.SqlException: Column name or number of supplied values does not match table definition

fabulaspb · Accepted Answer · 2016-01-02 17:01:38Z

1

You have error in your query. Try this.

BEGIN
     UPDATE Person 
         SET [CompanyLogo] = (SELECT TestCompanyLogo.* 
                              FROM OPENROWSET(BULK 'd:\test.png', SINGLE_BLOB) TestCompanyLogo)                    
END

answered Jan 2, 2016 at 17:01

fabulaspb

1,2538 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

inserting image in db table failes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related