测试环境SQL2005,windows2003 DECLARE @idoc int; DECLARE @doc xml; SELECT @doc=bulkcolumn FROM OPENROWSET( BULK 'D: test.xml', SINGLE_BLOB) AS x EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc SELECT * into #temp FROM OPENXML (@Idoc, '/Root/Item',2) WITH ( [ID] varchar(10) ,[Name]varchar(10) ,[Caption]varchar(1...
[ 查看全文 ]