Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-22 : 07:38:51
|
| Uma writes "I have a small question. Select * from employees where jobid =?Is there a way to make the system prompt the user to enter a value for jobid? I don't want to use a variable. Thanks,Uma." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-22 : 08:23:15
|
| Not with SQL. This is a task that your front end application would need to perform, then pass to SQL as a parameter.-------Moo. :) |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-22 : 12:34:46
|
| What's the application layer written in?Brett8-) |
|
|
|
|
|
|
Prompting the user for values on the fly!