Post reply

Question with running .sql file

  • March 3, 2011 at 10:17 am

    #233597

    Hi,

    I'm running a .sql batch file, but it is only giving me back the results and is not including the commands themselves. Since there are numerous commands in this batch, it is hard to know to which commands the results are refering, if the command is not listed before it. Any suggestions? Here is what I ran:

    SQL> START c:\folder\name.sql;

    Thank You Very Much for any help

  • March 3, 2011 at 10:46 am

    #1294161

    You could modify your current script to return the query or any other information before the actual statement.

    Something like

    SELECT 'query: SELECT * FROM sys.columns'

    SELECT * FROM sys.columns


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • March 3, 2011 at 11:51 am

    #1294205

    Ok I'll give that a shot.

    Thanks Again

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

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