SQL Server 200, XML and XSL

• Pshah2k

  Grasshopper

  Points: 11

  More actions

  June 11, 2003 at 12:52 pm

  #101516

  Hi,

  I am trying to findout if I can apply a XSL sheet on a select statement in Sql Server 200. I know I can get the results using FOR XML EXPLICIT. But I want to see if I can use XSL from SQL Server/

  Thanks,

  Pranav

• Melville

  SSCommitted

  Points: 1985

  More actions

  June 12, 2003 at 3:56 am

  #461017

  Pranav

  XSL is used to change the presentation of XML data, so I can't see how (or why) you would want to do this.

  Apply the XSL to transform the data when it is returned to the calling application, there is no sense in using XSL within the database.