Scripting Variable in String

Question

Hi Community,

Is it possible to intergrate variables in string? (Without concate symbol). This is much better for reading code.

This is possible in PHP Language for example. 

$MyVar = "World";
$string = "Hello $MyVar";
// another method
$string2 = sprintf("Hello %s", $MyVar);

Or is there something similar in T-SQL Language?

Answer 1

Hello,

In T-SQL? Not really, you would have to replace the value:

DECLARE @MyVar varchar(100);
SET @MyVar = 'World';

DECLARE @string varchar(100);
SET @string = 'Hello @MyVar';

SET @string = REPLACE(@string, '@MyVar', @MyVar);

SELECT @string

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hi,

depends on where you want to apply this! In case of dynamic sql using sp_executesql you can have a similar behavior(not exactly the same however).

Regards
satheesh

Answer 3

No. String processing is not a strong point of T-SQL.

Then again, you don't have reason to do this too often in T-SQL. If you are thinking of dynamic SQL, the answer is that you should use parameterised SQL. I discuss this in my article on dynamic SQL on
http://www.sommarskog.se/dynamic_sql.html

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 4

This is an very interesting article ... thank you

Answer 5

Bad for me. Not very casual for coding :-)

Answer 6

I think, dynamic SQL will work for me.