使用存储过程将xml数据传递到数据库 [英] passing xml data to database using stored procedure

问题描述

你好

我想使用存储过程将xml文件的内容传递给数据库.

应该是这样，我应该将xml文件的位置传递给存储过程，并且应该填充相应的记录.

请帮助我. :)还可以提供相关的替代方法

hello

i want to pass the content of xml file to a database using stored procedure.

it should be such that i should pass the location of the xml file to stored procedure and the corresponding records should get filled.

please help me out in this. :) can also provide a related alternative if possible

推荐答案

您需要将XML数据传递到存储过程，然后在SQL Server中，在存储过程原型. Google是您的朋友.

You need to pass the XML data to the stored procedure, and in SQL Server, specify a XML parameter in the stored procedure prototype. Google is your friend.

尝试一下，
http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx [ ^ ]

Try this,
http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx[^]

gr8 ..它起作用了，但是现在我遇到了这个错误

您无权使用批量加载语句.

我应该如何启用此权限?

gr8.. it worked but now i am getting this error

You do not have permission to use the bulk load statement.

how should i enable this permission?

这篇关于使用存储过程将xml数据传递到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！