[dba-SQLServer] Stringing USPs together

I am building a bunch of user stored procedures, which will eventually be
strung together in another usp.  However in order to do this I need to have
the USP ask me a question or two, like the name of the database.  Or is
there a variable that gives me the name of the database that the usp is in?

If I need to get variables into a usp how do I do so?  By that I mean how do
I get the USP to ask me a question and accept my answer and store it to a
variable?

John W. Colby
Colby Consulting
www.ColbyConsulting.com