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.