Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

Option to generate html format

I have a requirement for converting Oracle's CTX_DOC packages to SQLServer:
There is a function CTX_DOC.FILTER (which generates a plain text or HTML version of a document and stores it in a table).
Is there any option to generate a HTML/text version of document in SQLServer.
[287 byte] By [Srik] at [2008-2-15]
«« Using an object as input to the CR Designer and runtime
»» C# in 21 Days
# 1
There is no built-in method to do this. You can however write your own CLR stored procedure or UDF to do the same. You may also want to look at the Fulltext features in SQL Server.
UmachandarJayachandran-MS at 2007-9-9 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2
Thanks for your information. I 've planned to generate an XML file then view it via XSLT.
Here is a sample query:
select * from employee for xml auto
I tried to create Virtual Directories and invoked "IIS Virtual Directory Management for SQL Server". But i could not find any Default Web Site option. Is there any am missing here?
Srik at 2007-9-9 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified