HTML Output or something similar

• saint-911871

  Newbie

  Points: 1

  More actions

  March 4, 2009 at 8:44 am

  #206636

  I am new to SQL and am trying to get paragraphs into and out of a SQL database. I am not sure if I need to go with XML at this point to get rich text formatting, such as HTML. Any assistance would be greatly appreciated.

  Thank you for your time,

  Scott St. Gelais

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  March 5, 2009 at 12:34 pm

  #954305

  Hello saint

  I would suggest to use XML. After selection of data you can simply transform it with XSLT to HTML.

  Here a little example

  IF (OBJECT_ID('tempdb..#test') IS NOT NULL)

  DROP TABLE #test

  CREATE TABLE #test (id INT, first_name NVARCHAR(100), last_name NVARCHAR(100))

  INSERT INTO #test VALUES (1, 'Mikey', 'Mouse')

  INSERT INTO #test VALUES (1, 'Hoomer', 'Simpson')

  SELECT *

  FROM #test t

  FOR XML AUTO

  DROP TABLE #test

  Greets

  Flo