SQL Server Transact Basic to Expert - Insert Query With Image file

This blog we are going to do an image insert into the table. We have scenarios where we need to save an image file in the database at those scenarios we use varbinary(max) as the data type. Say in our example we have a column with that type.

Example:

Insert into emptable
(empid, empphoto)
Select 1, bulkcolumn
 from OPENROWSET(BULK 'c:\file\photo1', SINGLE_BLOB) As A