By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

How to read the xml and display using xslt from a DB in sql server2005

P: n/a
raj
Hi,
can anyone help me in fetching the xml value from the table of column
datatype xml,and i need to display the same using xslt and java.

Thanks in Advance
Raj
Sep 10 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
To retrieve and XML column you simply write a select statement:

SELECT xml_column
FROM Foo;

How you handle it on the client side and perform transformations, it
depends on the client API. Since you indicate Java, then it is best to
ask the question in the Java related newsgroups.

A quick search shows a few useful articles:
http://www.oreillynet.com/pub/a/orei...xslt_0801.html
http://www.javaworld.com/javaworld/j...908-xpath.html

--
Plamen Ratchev
http://www.SQLStudio.com
Sep 10 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.