SQL Server Performance

TSQL User Input

Discussion in 'T-SQL Performance Tuning for Developers' started by rgregor6, Jul 14, 2005.

  1. rgregor6 New Member

    When running a TSQL file is there any way of requesting the user to enter a value for a variable ?
    rgregor6, Jul 14, 2005
    #2

  2. ranjitjain New Member

    Hi,
    QA never runs a sp if no value given for input parameters.
    So the variable for which you want some value, make it as input parameter so the user will pass it while calling that stored procedure.
    ranjitjain, Jul 14, 2005
    #2

  3. rgregor6 New Member

    I was thinking more about a prompt asking for a users input. I can probably do this via a .bat file but was just wondering if it is was possible.
    rgregor6, Jul 14, 2005
    #2

  4. surendrakalekar New Member

    quote:Originally posted by rgregor6

    I was thinking more about a prompt asking for a users input. I can probably do this via a .bat file but was just wondering if it is was possible.
    In sql server there is no command/function to accept user input. By using parameters it is possible to accept input values in Ms-Access but not here.
    Is it possible in oracle?


    Surendra Kalekar

    surendrakalekar, Jul 14, 2005
    #2

  5. rgregor6 New Member

    In SQL*PLUS for Oracle there is an ACCEPT command that allows the script to prompt the user for an input.
    rgregor6, Jul 14, 2005
    #2

Share This Page