sqlZapisywaniedanychnadysk

-- show advanced options
EXEC sp_configure &＃39;show advanced options&＃39;, 1
GO
RECONFIGURE
GO
-- enable xp_cmdshell
EXEC sp_configure &＃39;xp_cmdshell&＃39;, 1
GO
RECONFIGURE
GO
-- hide advanced options
EXEC sp_configure &＃39;show advanced options&＃39;, 0
GO
RECONFIGURE
GO
EXEC master..xp_cmdshell &＃39;BCP "SELECT pad_Data FROM E3_Test_Mkidn_Test_1024_.dbo.BP_PackageData WHERE pad_Id = &＃39;&＃39;04E74182-A431-4A3B-B27C-1171ED5C3550&＃39;&＃39; " queryout "E:\exportdir\04E74182-A431-4A3B-B27C-1171ED5C3550.zip" -T -f E:\exportdir\formatfile.fmt -S &＃39;