sql server 2005 批量导入导出_数据库技巧

[重要通告]如您遇疑难杂症,本站支持知识付费业务,扫右边二维码加博主微信,可节省您宝贵时间哦!

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号又微信号)右上方扫一扫可加博主微信

所写所说，是心之所感，思之所悟，行之所得；文当无敷衍，落笔求简洁。 以所舍，求所获；有所依，方所成！