Select local xml file into table

I have a column in my table that is set as xslt (XML(.), not null).

Right now I have used a regular string to set it. Like this:


UPDATE table
SET xslt = 
'<xsl:stylesheet xmlns:xsl="http://ift.tt/tCZ8VR" version="1.0">
<xsl:template match="/">
<html>
  <head>
    <title> Results date with no risk </title>
  </head>
  <body>
    <xsl:apply-templates />
  </body>
</html>
</xsl:template>
<xsl:template match="data">
<table width="400" border="1">
  <tr bgcolor="#a0acbc">
    <td>KplusId</td>
    <td>strUser</td>
    <td>strName</td>
    <td>strPosName</td>
  </tr>
  <xsl:for-each select="row">
    <tr>
      <td>
        <xsl:value-of select="KPlusId" />
      </td>
      <td>
        <xsl:value-of select="strUser" />
      </td>
      <td>
        <xsl:value-of select="strName" />
      </td>
      <td>
        <xsl:value-of select="strPosName" />
      </td>
    </tr>
  </xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>'
WHERE ....

I would like to do something like this:


UPDATE table
SET xslt = C:\test\Test.xlm

Is this possible?

Select local xml file into table

No comments:

Post a Comment