SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[p_ZipFile]
@xlspath nvarchar(4000)
,@outpath nvarchar(4000)
as
/*
declare @xlspath nvarchar(4000)
declare @outpath nvarchar(4000)
select @xlspath='D:\WebRoot\test123.xls'
select @outpath='D:\WebRoot\test123.rar'
*/
declare @cmd nvarchar(4000)
--select @cmd='""%ProgramFiles%\WinZip\Wzzip.exe"" -m -j '+@outpath+' ' + @xlspath --zip（!!!Note: Must install WINZIP and WinZip Command Line Support Add-On）
select @cmd='""%ProgramFiles%\WinRAR\Rar.exe"" a -ep1 -df '+@outpath+' ' + @xlspath --rar
print @cmd
exec master..xp_cmdshell @cmd
