Post reply

Syntax for newline?

  • January 5, 2004 at 12:21 pm

    #106722

    I am writing a script to update a database, with PRINT staements to indicate that each step has completed. I would like to format this output in order to make it more readable - can someone tell me please how to specify newlines in the code?

    Thanks!


    SELECT * FROM users WHERE clue > 0
    0 rows returned.

  • January 5, 2004 at 12:31 pm

    #488689

    You mean something like this

    PRINT 'This is the first line'

    +CHAR(10)+CHAR(13)

    + 'This is the second line'

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 5, 2004 at 12:53 pm

    #488696

    Yup, this is exactly what I was after thanks!


    SELECT * FROM users WHERE clue > 0
    0 rows returned.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply