Add [ code ] tag to IFCode shortcuts

• MrBaseball34

  SSCrazy

  Points: 2515

  More actions

  July 30, 2008 at 12:20 pm

  #850764

  Jack Corbett (7/30/2008)

  ---

  Also it would be nice if people would use the IFCodes period. How many times is ... a url not in a url block?

  *MOST* good forum software will have an option to automatically parse URLS and emails

  and format them correctly.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  July 30, 2008 at 12:27 pm

  #850770

  MrBaseball34 (7/30/2008)

  ---

  Jack Corbett (7/30/2008)

  ---

  Also it would be nice if people would use the IFCodes period. How many times is ... a url not in a url block?

  *MOST* good forum software will have an option to automatically parse URLS and emails

  and format them correctly.

  I like to put my answers into url tags to make them look like links. 😎

• Phil Factor

  SSC-Insane

  Points: 20244

  More actions

  July 31, 2008 at 2:32 am

  #851080

  Yes, the Prettifier is still there to translate SQL code into IFcodes. on http://extras.sqlservercentral.com/prettifier/prettifier.aspx?style=5

  The style=5 at the end puts you straight into IFcode style. It would certainly be neat to be able to put code between [SQL] [/SQL] blocks, and it has certainly been discussed. An advantage of the prettifier is that you can then highlight parts of your code or emphasise bits.

  [font="Courier New"]

  SELECT p1.CategoryId,

            ( SELECT ProductName + ','

                [highlight="yellow"]FROM Northwind.dbo.Products p2

               [/highlight]WHERE p2.CategoryId = p1.CategoryId

               ORDER BY ProductName

                 FOR XML PATH('') ) AS Products

        FROM Northwind.dbo.Products p1

       GROUP BY CategoryId ;

  [/font]

  Best wishes,
  Phil Factor