</Product> <Product> <ProductID>2</ProductID> <ProductName>Chang</ProductName> </Product> </Category> 不带FOR XML EXPLICIT语句的结果为: Tag Parent Category!1! ID Category!1!Name Product!2! Product!2! ProductID!element ProductName!element ---- ------- ---------- ------------ -------------------------- ---------------------------- 1 NULL 2 Condiments NULL NULL 2 1 2 Condiments 3 Aniseed Syrup 2 1 2 Condiments 4 Chef Anton''''s Cajun Seasoning 1 NULL 1 Beverages NULL NULL 2 1 1 &n << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> |