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
SQL Server Transact Basic to Expert - Insert Query With Image file
SQL Server Transact Basic to Expert - Insert Query With Image file
Join the conversation! Your thoughts help the community grow.