摘要： DECLARE @xmlText xml ,@idoc int set @xmlText = (select doc from openrowset(bulk 'C:\Word\SRC\WebApp\Demo\XML\XMLFile.xml',single_blob) as t(doc)) --select @xmlTextEXEC sp_xml_preparedocument @idoc OUTPUT,@xmlText--insert into TB_TB_Category-- (Cid, Name, ParentCid)--select [cid],[name],[pare 阅读全文

摘要： select*fromopenrowset('sqloledb','ip';'user';'pwd','exec库..过程') 阅读全文