/*   
	Import file binary into Columns in SQL tables

	The Process:
		Creates a sample student temp table 
		Builds a cursor set of all student records 
		Iterates the cursor 
			Building dynamic SQL to load the image into the student record, and 
			Executing the dynamic SQL 
		Cleans-up the cursor 
		Removes the temp table 
*/

/* Example student table... replace the table/column names below */
Create TABLE #StudentTable (StudentID Int, FileImage image) 
Insert Into #StudentTable 
	Select 3708,NULL UNION 
	Select 3709,NULL UNION 
	Select 3710,NULL 

/* now setup the necessary variables and create the cursor. */
Declare @StudentID int /* the identifier of the record to be updated with the bin */ 
Declare @FileImagePath nVarChar(255) = 'C:\Temp\' /* the location of the source files (SQL must have access) */ 
Declare @RunMe nVarChar(Max) /* the dynamic SQL to load the image file */

DECLARE workCursor CURSOR FOR 
	Select  
		StudentID, 
		@FileImagePath + 'IMG_' + Cast(StudentID as nVarChar(128)) + '.JPG' as FileName /* you will need to change this to your file name pattern */ 
	From #StudentTable 
	Where FileImage is null /* remove this if overwriting pictures is ok */ 
	Order By StudentID 

/* open (run the query) the cursor and get the first row's contents into working variables */
OPEN workCursor
FETCH NEXT FROM workCursor INTO @StudentID, @FileImagePath

WHILE @@FETCH_STATUS = 0
Begin

	Set @RunMe = '
		Update #StudentTable 
		Set FileImage = (
				Select * From openrowset(BULK '''+ @FileImagePath + ''', SINGLE_BLOB) ToLoad
				) 
		where StudentID = ' + Cast(@StudentID as nVarChar (10)) 

	Exec (@RunMe)

	FETCH NEXT FROM workCursor INTO @StudentID, @FileImagePath 
End

/* clean up the cursor after use */ 
CLOSE workCursor
DEALLOCATE workCursor

Select * From #StudentTable

Drop TABLE #StudentTable