How to Prompt a user for Input from keyboard

[arj26]

Hi,
How do you prompt a user for input from the keyborad and then track that value and use it in a query using Microsoft SQL Server 2000.

 

[tlbroadbent]

Write a program in VB, ASP, C++, etc. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[arj26]

Thanks

 

[Databaseguy]

Alter PROCEDURE sp_Prompt @Prompt VARCHAR(25)
AS
SELECT * FROM YourTable
WHERE yourField = @Prompt

This will prompt your user and pass the variable into the procedure.



Tyrone Lumley
augerinn@gte.net

 

[arj26]

Thanks for your help, but in my installation of SQL Server 2000 i don't have any procedure called sp_prompt, there are scores of other sp_* procedures but not this one. Is it an automatic installation procedure? Any help on this would be sincerely appreciated. Thanks.

 

[tlbroadbent]

There is no sp_Prompt stored proc. I think Databaseguy was suggesting that you write a stored procedure and pass the prompt to the procedure as a variable. sp_prompt appears to be a generic example of what you can do with a stored proc. Perhaps, Databaseguy will correct me if I'm wrong. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm