DECLARE
@imgString varchar(80),
@insertString varchar(3000),
@imgNumber int

SET @imgNumber = 1

WHILE (@imgNumber <= 100)
BEGIN

SET @imgString = 'D:\MPPICTURES\PP' + CONVERT(nvarchar,@imgNumber) + '.jpg'

SET @insertString= N'update tblEmp
set PICTURES = (SELECT * FROM OPENROWSET(BULK N''' + @imgString + ''', SINGLE_BLOB) as tempImg)
WHERE EmpID = ''' + CONVERT(nvarchar,@imgNumber) + ''''
EXEC(@insertString)
SET @imgNumber = @imgNumber + 1

END

GO