Post reply

Anybody know if there''s a way...

  • January 12, 2005 at 11:51 am

    #60594

    Is there a way to generate an inputbox and receive data from a user interactively in T-SQL for use inside a stored procedure while it is running in Query Analyzer on SQL Server 2000 sp3a?

     

     

    Steve

  • January 12, 2005 at 12:01 pm

    #537099

    Query Analyzer <> MS Access

    Sorry

     


    * Noel

  • January 12, 2005 at 12:43 pm

    #537114

    well one way that almost looks like what you are wanting to do is to debug the SP. In QA select your stored proc in the object browser and right click / debug.

    You will then be able to manually enter a value for each parameter. While this is good for developping, that can't, in any way be used in a production environement.

  • January 13, 2005 at 11:53 am

    #537355

    You'd probably want to build a front-end app to get the user input and call the stored procedure.  Access can make that very simple to do.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

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

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