Cacher is the code snippet organizer for pro developers

1. Włączenie cmdshell

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO


2. Pobranie pliku/ów

EXEC master..xp_cmdshell 'BCP "SELECT pad_Data FROM [nazwa_bazy].[dbo].[BP_PackageData] WHERE pad_id = ''B33CA01B-B2E6-47E3-BE1F-36DB72227319''" queryout "D:\export\paczka.zip" -T -f D:\export\formatfile.fmt'


3. Wyłączenie cmdshell

EXEC sp_configure 'xp_cmdshell', 0
GO
RECONFIGURE
GO
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO

10.0
1
1       SQLBINARY           0       0       ""   1     MyColumn             ""