INSERT INTO Employ ( Name, Photo,Id) values
SELECT 'John', BulkColumn
FROM Openrowset( Bulk D:\Arvind@Work\Image\Blue hills.jpg, Single_Blob) as EmployeePicture ,10;
Enable OpenRowset Support on surface area configuration of sqlserver configuration tool, and then adjust the above query to
INSERT INTO Employ ( Name, Photo,Id)
SELECT 'John', EmployeePicture.BulkColumn
FROM Openrowset( Bulk D:\Arvind@Work\Image\Blue hills.jpg, Single_Blob) as EmployeePicture ,10;