declare @filename nvarchar(255)
        , @filedata varbinary(max)
        , @ObjectToken int;


set @filename = 'C:\temp\mysuperfile.txt';

select @filedata = data
from mytable
where name = 'myfilename';

exec sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT;
exec sp_OASetProperty @ObjectToken, 'Type', 1;
exec sp_OAMethod @ObjectToken, 'Open';
exec sp_OAMethod @ObjectToken, 'Write', NULL, @filedata;
exec sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @filename, 2;
exec sp_OAMethod @ObjectToken, 'Close';
exec sp_OADestroy @objectToken;

bcp "select Data from mydatabase.myschema.mytable" queryout "C:\temp\myfile.txt" -V90 -T -S MYSQLSERVER -f C:\temp\temp.fmt

cкачать