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 |
|
Roy Slade
Starting Member
7 Posts |
 Posted - 2005-07-12 : 09:38:20
|
| I'm trying to prompt for a simple string to be placed in a variable and used later in the query, but I can't find anything that will present a prompt to the user. I found UserInput, but the BOL entry is less than informative.Thanks! |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-07-12 : 09:41:27
|
| What are you using for your front end? ASP? .NET? Access? Excel? Notepad?*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
 |
|
|
Roy Slade
Starting Member
7 Posts |
Posted - 2005-07-12 : 09:49:10
|
| I'd like to do this in plain T-SQL. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-07-12 : 09:51:18
|
| So, you are saying your user is going to be using Query Analyzer? Or Enterprise Manager?*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-12 : 09:51:37
|
| I dont think this is possible until you use stored procedure with input parameters and run it in Debug modeMadhivananFailing to plan is Planning to fail |
|
|
|
Roy Slade
Starting Member
7 Posts |
Posted - 2005-07-12 : 09:54:57
|
| It will eventually wind up in a DTS package that the user starts with the DTSRUN command. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
|
|
|
|
|
How do I ask the user a question