Concat parameter in a message

Question

Concat parameter in a message

AVDR

SSC-Addicted

Points: 418
More actions
June 2, 2014 at 12:28 pm

#289496

Hi,
I have a procedure (a) where i call another procedure (b) passing @message as a parameter to procedure B.
Ex:
Create procedure a
as
Begin
declare @prevyear
exec b @message = 'avvasdva' + cast(@prevyear as varchar)
End
When i execute above procedure, i get error at + sign i.e. @message parameter. how can i concatenate string with another parameter when passing parameters

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

vasuarjula (6/2/2014)
Hi,
I have a procedure (a) where i call another procedure (b) passing @message as a parameter to procedure B.
Ex:
Create procedure a
as
Begin
declare @prevyear
exec b @message = 'avvasdva' + cast(@prevyear as varchar)
End
When i execute above procedure, i get error at + sign i.e. @message parameter. how can i concatenate string with another parameter when passing parameters

Check out this page and if you have any further questions, feel free!

😎

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Parameters cannot be expressions.

http://stackoverflow.com/questions/12009832/how-to-concatenate-string-when-setting-a-parameter-in-transact-sql

Specify Parameters

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

Koen Verbeeck (6/2/2014)
Parameters cannot be expressions.
http://stackoverflow.com/questions/12009832/how-to-concatenate-string-when-setting-a-parameter-in-transact-sql
Specify Parameters

That's step one, for sure. Step 2 is that the variable is assigned no value and will always return a NULL for the result of the concatentation. Step 3 is that the variable if the variable is provided from sources external to the proc, a check needs to be done for SQL Injection.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)