Accepting Input at Runtime.

Hi People,

I’m working on a Microsoft SQL database. I want to create a stored procedure that will prompt me for input at runtime. How do I go about this please? I need this info urgently.

Thanks