开发者

is it a good idea to write a stored procedure for storing an XML in SQL?

开发者 https://www.devze.com 2023-01-08 21:25 出处:网络
i want to write a stored procedure in java for SQL to parse and store the xml automatically in the corresponding tables is it a good idea or any one guide开发者_Python百科 me how to do it.

i want to write a stored procedure in java for SQL to parse and store the xml automatically in the corresponding tables is it a good idea or any one guide开发者_Python百科 me how to do it.

thanx in advance


XML is a great way to store scratch data. MSSQL has awesome support for shredding/querying xml documents.

http://msdn.microsoft.com/en-us/library/ms345117(SQL.90).aspx


The xml?

Can you provide an example?

If you are trying to build xml, I think how I would do it is with a template engine such as one of these: (java template engines)

And load all the data you need from sql into that template file.

Or

If you are trying to parse XML I strongly recommend not doing so in sql. Use a xml parsing library to unpack that baby and then maybe a stored proc to put in a database.

To go backwards look at my solution above.

Xml is not an easy thing to parse or create. Jeff Atwood Agrees.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号