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

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.