专注于互联网--专注于架构

oracle导入导出:sql server 2005 批量导入导出

declare @CMD_STR varchar(100) declare @i declare @memo nvarchar(50) @memo='数据分离' @i=0while @i<=153begin insert o 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 - [阅读全文] [PDF]