SQL server t-sql limitation

1. Cannot use + in the parameter, say when you try to call a procedure with a parameter: @param1+'Test'
It's not supported, you have to define a new variable and set @param1+'Test' to the new variable and then call the procedure with the parameter
2. Cannot call procedure from function, need to use procedure with output parameter