Post reply

Append output from SQLCMD in batch file

  • June 15, 2009 at 10:08 am

    #1009750

    carissa.chris (6/15/2009)

    I wanted a "forever" log and the ">> E:\output.txt" accomplishes exactly what I needed. Thanks for all the input.

    🙂

    Ok... you guys can remove the handrails, now. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 15, 2009 at 1:28 pm

    #1009879

    Jeff Moden (6/15/2009)

    Ok... you guys can remove the handrails, now. 😛

    ..... getting out the reciprocating saw .... or will that cause too much damage where the handrails are installed at? :w00t:

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 15, 2009 at 1:46 pm

    #1009890

    WayneS (6/15/2009)

    Jeff Moden (6/15/2009)

    Ok... you guys can remove the handrails, now. 😛

    ..... getting out the reciprocating saw .... or will that cause too much damage where the handrails are installed at? :w00t:

    Heh.... no.... a simple "unscrewing" will do. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 15, 2009 at 8:22 pm

    #1009990

    Jeff Moden (6/15/2009)

    WayneS (6/15/2009)

    Jeff Moden (6/15/2009)

    Ok... you guys can remove the handrails, now. 😛

    ..... getting out the reciprocating saw .... or will that cause too much damage where the handrails are installed at? :w00t:

    Heh.... no.... a simple "unscrewing" will do. 😀

    You know Jeff, I have to admit that you have a way of bringing a smile to my face... Thanks!

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • December 1, 2009 at 6:21 am

    #1085728

    [Borrowing the thread]

    The ">>" "operator" was exactly was I was looking for (wanted appending feature to sqlcmd), it does what I want.

    Unfortunately it seems not to support the same "codepage (1252)" as "-o" does.

    Being in Sweden I miss my "special" characters.

    Any workarounds/tricks on that “issue” Jeff?

Viewing 5 posts - 16 through 19 (of 19 total)

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