Loading

Insert Image into sql table without converting it into the Byte array.............

Ankur Gupta

Comments

Join the conversation! Your thoughts help the community grow.

Insert Image into table without converting it into the Byte array.............

INSERT INTO Employees (Id, Name, Photo) SELECT 10, 'John', BulkColumn from Openrowset( Bulk 'C:\photo.bmp', Single_Blob) as EmployeePicture

This command will insert image in sql table directoly without any conversion.