SQL Server Performance Forum – Threads Archive

TSQL User Input

When running a TSQL file is there any way of requesting the user to enter a value for a variable ?

---

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.

---

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

---

In SQL*PLUS for Oracle there is an ACCEPT command that allows the script to prompt the user for an input.

---

]]>