XML数据的StoredProcedure [英] StoredProcedure for XML data

问题描述

我想在Xml文件中写入gridview数据并将该xml文件作为输入参数传递给

存储过程并将xml文件数据插入到sql数据库表中.

我不怎么写xml文件以及如何将其传递给存储过程


谁能帮我做到这一点.



在此先感谢

i want to write gridview data in Xml file and pass that xml file as input parameter to

store procedures and insert xml file data to sql database table.

i dont how to write xml file and how to pass it to store procedure


can any one help me to do this.



Thanks in advance

推荐答案

关注此内容: http ://msdn.microsoft.com/zh-CN/library/ms187093.aspx [ ^ ]

在以下位置的工作示例语句:
http://blog .sqlauthority.com/2012/04/27/sql-server-introduction-to-discovering-xml-data-type-methods-a-primer/ [

follow this : http://msdn.microsoft.com/en-us/library/ms187093.aspx[^]

Working sample statements at :
http://blog.sqlauthority.com/2012/04/27/sql-server-introduction-to-discovering-xml-data-type-methods-a-primer/[^]

这篇关于XML数据的StoredProcedure的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！