[重要通告]如您遇疑難雜癥,本站支持知識付費業務,掃右邊二維碼加博主微信,可節省您寶貴時間哦!

declare @CMD_STR varchar(100)
declare @i int
declare @memo nvarchar(50)
set @memo=數據分離
set @i=0
while @i<=153 begin insert into t select top 15000 * from dbo.gceclub_member_email select @CMD_STR= bcp jive.dbo.t + out C:\TDDOWNLOAD\test\ + @memo+cast(@i as nvarchar(20)) + .xls+ -c -S 127.0.0.1 -U sa -P bizcom EXEC master.dbo.xp_cmdshell @CMD_STR delete from dbo.gceclub_member_email where Col001 in (select Col001 from t) delete from t set @i=@i+1 end USE master EXEC sp_configure show advanced options, 1 RECONFIGURE WITH OVERRIDE EXEC sp_configure xp_cmdshell, 1 RECONFIGURE WITH OVERRIDE EXEC sp_configure show advanced options, 0

問題未解決？付費解決問題加Q或微信 2589053300 (即Q號又微信號)右上方掃一掃可加博主微信

所寫所說，是心之所感，思之所悟，行之所得；文當無敷衍，落筆求簡潔。 以所舍，求所獲；有所依，方所成！