摘要:
数据倒入还是建议用 bcpif exists (select * from tempdb..sysobjects where id = object_id(N'tempdb..#T')) drop table [#T]Create table #T(id int identity(1,1) not null, remark varchar(8001) null)Insert into #TExec master.dbo.xp_cmdshell 'type e:/data.txt' select * from #T剩下就靠你自己 根据"数据类型" 阅读全文