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 |
|
jrowan
Starting Member
1 Post |
 Posted - 2006-01-11 : 11:47:53
|
| I would like to setup a query where the user is firstly prompted to input the information e.g. if they are trying to locate a particular person from a telephone database they would be prompted to enter the surname for that person. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-01-11 : 11:54:43
|
| Do you have a question?CODO ERGO SUM |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-11 : 11:56:38
|
| u should have a client application for that (I mean prompt)Once the user enters data in the client application, that can be used to create a SQL query and pass to the database and get the desired result. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-11 : 12:20:41
|
| Use either a frontend VB desktop app or a web page to prompt for user info |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-12 : 00:05:49
|
| In Access if you write querySelect columns from table where firstname=?Then it will prompt you when you run the query. But that feature is not supported in SQL Server. You need to use Front End application as suggestedMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Running query from user input