Unix Technical Forum

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

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 09-12-2008, 05:23 PM
raj
 
Posts: n/a
Default How to read the xml and display using xslt from a DB in sql server2005

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 09-12-2008, 05:23 PM
Plamen Ratchev
 
Posts: n/a
Default Re: How to read the xml and display using xslt from a DB in sqlserver 2005

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads for: How to read the xml and display using xslt from a DB in sql server2005

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


All times are GMT. The time now is 05:01 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com