prompt user to enter parameters

[CRuser89]

Hello everyone,

I am new to SQL Server. We're currently using SQL Server 2005. Please see example below:

create procedure proc4 (@p1 char(15), @p2 char(20), @p3 int) as
insert into Workers
values (@p1, @p2, @p3)
go

Is there a way to write the code so that it prompts the user to enter in the parameters? For example, when the user runs the script to create the procedure, a box will pop up and ask the user to enter in parameter one, then parameter 2, etc? I know that this can be done w/oracle but not sure if there's a way to do it w/sql server.

Thanks,
Kathy

 

[jbenson001]

I think you will need some sort of front-end application to prompt the users for input.

 

[CRuser89]

Thanks jbenson....

 

[Qik3Coder]

Cruser89, what type of user are you talking about?

if it is QueryAnalyzer(QA) user, they can just run the stored procedure with the parameters after the name. Otherwise you will need some actual application, at the very least MS Access.

Thanks,

David

Without Tek-Tips I would go Codal
-implementing random bugs for the sake of something to do.