declare @KeyField int
declare @FileName nvarchar(1000)
declare @bcpCommand nvarchar(4000)
 
DECLARE c1 CURSOR FOR 
SELECT CustomerId
FROM dbo.Customer
WHERE CustomerId=114230
OPEN c1

FETCH NEXT FROM c1
INTO @KeyField

WHILE @@FETCH_STATUS = 0
BEGIN

-- Create unique name for the file using KeyField from the table
SELECT @FileName = 'C:\ttt\' + convert(varchar(18), @KeyField) + '.jpg'

SET @bcpCommand = 'bcp "SELECT Picture FROM [dbo].[Customer] WHERE CustomerId = ' + convert(varchar(18), @KeyField) + '" queryout "'
SET @bcpCommand = @bcpCommand + @FileName + '" -S MyServer\SQL2014 -T -n'


PRINT @bcpCommand
EXEC master..xp_cmdshell @bcpCommand, no_output

FETCH NEXT FROM c1
INTO @KeyField

END

CLOSE c1
DEALLOCATE c1