Insert and Update image field in SQL Server 2008/2005

Ok, now let us move ahead with our script in SQL Server itself.

--create table for demonstration

create table emps

(

      name varchar(50),

      dept varchar(10),

      empImg image

)

GO

--insert statement with single_blob to upload image to SQL Server

INSERT INTO emps([Name],dept,empImg)

SELECT 'Ritesh','MIS',

(select * FROM OPENROWSET(BULK'C:\Ritesh.JPG', SINGLE_BLOB) AS img)

GO

--check the inserted data

select * from emps

GO

--update your table, along with image also.

update emps

set empImg=(select* FROM OPENROWSET(BULK'C:\Ritesh1.JPG', SINGLE_BLOB) AS img), dept='IT'

where name='Ritesh'

GO

--check the data whether it has been updated

select * from emps

go

 

Happy SQLing!!!