Prompt for User Input

[Carin Botha]

I want to create a Stored Procedure or a view and ask for user input.

Example: Select name from partner where code = 'User Input'.

Could you help please?

[ck9663]

I want to create a Stored Procedure or a view and ask for user input.

Example: Select name from partner where code = 'User Input'.

Could you help please?

SQL-Server is primarily designed to be used as back-end storage of your data. Your requirement can be easily be resolve by using a Graphical User Interface (GUI) created by any front-end tool. You can create a form of some sort that can prompt user for input, then connect to your sql-server db. You have to create a stored proc that accepts the user input as a parameter and you can use it's value inside the stored proc. If you need to return a value, you might want to use function. In some cases (ie ASP), stored proc can return a value as recordset.

Hope this helps.

-- CK

[Carin Botha]

SQL-Server is primarily designed to be used as back-end storage of your data. Your requirement can be easily be resolve by using a Graphical User Interface (GUI) created by any front-end tool. You can create a form of some sort that can prompt user for input, then connect to your sql-server db. You have to create a stored proc that accepts the user input as a parameter and you can use it's value inside the stored proc. If you need to return a value, you might want to use function. In some cases (ie ASP), stored proc can return a value as recordset.

Hope this helps.

-- CK

Thx, I tought so. Will look at a work around then.
Regards