(SQL Server) Markdown to HTML - Full Document, Raw

See more Markdown Examples

Demonstrates how to convert a complete Markdown document to HTML using the raw theme. With the raw theme, only the HTML elements are generated, excluding:

Document Type Declaration (e.g. <!DOCTYPE html>)
Root Element (e.g., <html> )
Head Section
Enclosing <body> and </body> elements
Closing </html> element

Note: This example requires Chilkat v11.2.0 or greater.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @options int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @options OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @options, 'UpdateString', @success OUT, 'theme', 'raw'

    DECLARE @sbMarkdown int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbMarkdown OUT

    DECLARE @sbHtml int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbHtml OUT

    EXEC sp_OAMethod @sbMarkdown, 'LoadFile', @success OUT, 'qa_data/markdown/test1.md', 'utf-8'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @sbMarkdown, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @options
        EXEC @hr = sp_OADestroy @sbMarkdown
        EXEC @hr = sp_OADestroy @sbHtml
        RETURN
      END

    EXEC sp_OAMethod @sbMarkdown, 'MarkdownToHtml', @success OUT, @options, @sbHtml
    EXEC sp_OAMethod @sbHtml, 'ToCRLF', @success OUT

    EXEC sp_OAMethod @sbHtml, 'GetAsString', @sTmp0 OUT
    PRINT @sTmp0

    -- Sample markdown input:
    -- (See sample HTML output below.)

    -- 

    -- Sample HTML output:

    -- 

    EXEC @hr = sp_OADestroy @options
    EXEC @hr = sp_OADestroy @sbMarkdown
    EXEC @hr = sp_OADestroy @sbHtml


END
GO