master.dbo.xp_cmdshell 'osql -Usa -P -Q"select * from pubs.dbo.t2 FOR XML AUTO" -o c:\test.xml',NO_OUTPUT
go
create table txml(str ntext)
goBULK INSERT pubs..txml FROM 'c:\test.xml'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
select * from pubs..txml
go
create table txml(str ntext)
goBULK INSERT pubs..txml FROM 'c:\test.xml'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
select * from pubs..txml
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货