********************* 导入 xml文件 DECLARE @idoc int DECLARE @doc varchar(1000) --sample XML document SET @doc =’ <root> <Customer cid= C1 name= Janine city= Issaquah > <Order oid= O1 date= 1/20/1996 amount= 3.5 /> <Order oid= O2 date= 4/30/1997 amount= 13.4 >Customer was very satisfied </Order> </Customer> <Customer cid= C2 name= Ursula city= Oelde > <Order oid= O3 date= 7/14/1999 amount= 100 note= Wrap it blue white red > <Urgency>Important</Urgency> Happy Customer. </O...
查看详细内容 >>