示例:
.net
DataSet ds=....
string
SQL :
DECLARE @idoc int; EXEC sp_ N'<User>\r\n
<Dept>\r\n
<ItemID>1</ItemID>\r\n
<EmpID>123</EmpID>\r\n
<Type>0</Type>\r\n
</Dept>\r\n
<Dept>\r\n
<ItemID>2</ItemID> \r\n
<EmpID>123</EmpID>\r\n
<Type>1</Type>\r\n
</Dept>\r\n
</User>';
INSERT INTO A (ItemID,EmpID,Type)
SELECT ItemID,EmpID,Type FROM OPEN WITH (ItemID int,EmpID nvarchar(50),Type int);
原标题:存储过程 保存 xml 数据
关键词:xml