Post reply

Displaying a temp table in code

  • September 7, 2007 at 10:05 am

    #174627

    I am a beginner and was wondering how I can print the information held in a temp table as my code is executing? I know I need to use the print statement and a select statement in my code, but I don't know what the exact syntax is for the script. I am modifying existing written code and need to view the data in the table at different areas throughout the stored procedure. This way I can figure out where my changes need to be made.

     

    Tahnks in advance for your help

  • September 7, 2007 at 11:13 am

    #732228

    Just add a 'SELECT * FROM #TempTable' where you need to view the data.  There is no need to use the PRINT statement to view the data.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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