This is a discussion on How to read the xml and display using xslt from a DB in sql server2005 within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, can anyone help me in fetching the xml value from the table of column datatype xml,and i need ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| no controlling tty and no DISPLAY. Cannot read passphrase | Dave Martini 1 | Sun Managers | 0 | 06-29-2008 10:56 AM |
| How can I read display message from a C function | Fay Du | pgsql Sql | 1 | 04-19-2008 01:31 PM |
| How to use function based index in SQL Server2005? | Steven | SQL Server | 1 | 03-01-2008 03:25 PM |
| Seek method, table-direct, and sql server2005 | Manuel Lopez | SQL Server | 11 | 02-29-2008 07:23 AM |
| XML XSLT Table display | Pradeep | Oracle Database | 1 | 02-26-2008 08:50 AM |