How can i change name of variable ?

[TALHAKOSEN]

Hi all, I want to learn that, can i change name of variable, i mean i wanna have @s1, @s2, @s3 ... @s20 but i dont wanna write it wanna use WHILE X<20 BEGIN DECLARE @SX X=X+1; END CAN I DO THAT pls help

Sampiyon FENERBAHCE

[Ashfield]

Can't be done.

Bob Ashfield Consultants Ltd

[Wendelius]

When using SQL as the way you described, no. However, if you use dynamic SQL, meaning you create a string that contains the SQL statement and execute it, this can be done.

The need to optimize rises from a bad design