代碼如下:declare @intDoc int ? ? ? ? ? ? ? ? ? ? ? ? --保存加載文檔的句柄declare @xmlContent varchar(max) ?--將要加載的xml內(nèi)容print(len(@xmlContent)) set @xmlContent='<persons><person name="luisan" sex="man" address="shannxibaoji"></person><person name="luisan" sex="man" address="shannxibaoji"></person><person name="luisan" sex="man" address="shannxibaoji"></person><person name="wanghong" sex="man" address="shannxibaoji"></person><person name="wanghong" sex="man" address="shannxibaoji"></person></persons>' print(@xmlContent) exec sp_xml_preparedocument @intDoc output,@xmlContent ?--將xml的內(nèi)容加載到內(nèi)存中select * from openxml(@intDoc,'persons/person') with([name] varchar(10) '@name',[sex] char(3) '@sex',[address] char(20) '@address')--這塊with貌似是將結(jié)果集重新整合成一個新表展示?? exec sp_xml_removedocument @intDoc ?--將處理過得xml從內(nèi)存中刪除