How do I pass a text column as a parameter to another stored procedure

[thinkrajesh]

Hi,

I have a stored procedure which accepts a text datatype as a parameter..

I need to call this stored procedure from within another stored procedure..

How do I pass a text datatype as parameter?

Regards,
Rajesh Pillai

 

[DaOtH]

Rajesh,

something like:


EXEC procProcedure @parameter= 'text'


Where the following is the procedure that will be called:

CREATE PROCEDURE procProcedure

@parameter varchar(10)

AS
....

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963