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 |
|
elenabul
Starting Member
7 Posts |
 Posted - 2006-07-21 : 14:43:17
|
| Hi, I want to create some workflow that:1. run a sp( exemple sp_getUserId)2. print the result( exemple 123)3. AKS THE USER TO CONFIRM A CHOICE!!( Do you like to delete user 123)4. get the result from the console ( click “Y” for yes ….)5. run the sp_DeteleUser if the answer is YesI don’t want to use any UI. The question is if the SQL server has function to get the user input? If not how can I write c++ console application to achieve that goal.Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-21 : 14:48:32
|
quote:
The question is if the SQL server has function to get the user input? If not how can I write c++ console application to achieve that goal.
SQL Server is a dbms and not a programming language. For an application UI, you will need to write an application. Good luck on getting C++ help though. You'll probably want to buy a book that deals with C++ and databases. If you were to use .NET languages (such as C#), you would be able to get help easier.Tara Kizer |
 |
|
|
|
|
|
user input to stored procedure