Create Variable when needed (dynamic)

mkhan · February 22nd, 2006, 12:44 AM

Hi,

Is it possible to create dynamic variables in SQL Server 2000? I mean, I want my stored procedure to create variable and declare it, only when needed.

For example,

I have got a variable called, @str0 of type varchar(4000). When the limit is full then it will create a variable @str1 of type varchar(4000). When that limit is full then it will create another variable @str2, @str3, @str4 â¦.

Can someone please advice how can I do it in SQL server 2000?

Thanks in advance
Rashed

SQLScott · February 22nd, 2006, 11:01 PM

No, as far as I know, this is not possible.