Can anyone help regarding stored procedure

[adasoft]

Hi,

I am having one stored procedure named SP1 which is having one input and one output parameter. I have write another stored procedure named SP2 which is creating a dynamic SQL statement like

@variable = 'exec ' + @CURR_PROC_NAME + ' '''+ @STR_Var_VARCHAR + ''' , @STR_RETURN_STRING OUTPUT

and later printing and executing this like

print @STR_EXECUTE_QRY

EXEC (@STR_EXECUTE_QRY)

I have declared all three variables in the SP2

but it always says to declare @STR_RETURN_STRING variable. Can I do like above? If yes then how? If no then why?

With thanx in advance,
Adasoft

 

[SQLDenis]

you can't do that like that with dynamic SQL
try using sp_executesql()

read here (

http://www.sommarskog.se/dynamic_sql.html#sp_executesql)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[adasoft]

Hi SQLDenis,

Thanx a lot for the responce. Your link is useful enough for me.

With regards,
Rajendra