CODEWITHSUNDEEP
sqlsql-serverstored-procedures
Black Dagger
Black Dagger

Reputation: 399

User Input during stored procedure

Is it possible to take a user input during the time when the stored procedure runs? Like pause for a moment and ask for a user input and then continue?

There is a parameter @query inside my stored procedure and I want the option in which the user can modify the value of this parameter at a certain point of the procedure.

Possible?

Upvotes: 3

Views: 1721

Answers (2)

aaaaahhhhh
aaaaahhhhh

Reputation: 151

You basically should not expect SP to do this. The correct way of making use of SP is actually separate what you wanna do into multiple smaller SP and use your UI to control it. You may wanna refer to this

Upvotes: 2

Elmer
Elmer

Reputation: 135

No, I don't think this is possible.

You might want to look at CLR Stored Procedures: http://technet.microsoft.com/en-us/library/ms131094.aspx

They allow the full .NET framework inside sprocs. But even then, I don't see how you could stop for user input.

Upvotes: 2

Related Questions