Local variable limitations / Prove

I dont think there is any.... If so, it would be so large numbers, which would not cause any problems.

Also it depends on the memory the server has for this.

:)

www.abhisheksur.com

Sarvesh, if this helps please login to Mark As Answer. | Alert Moderator

Hi

1. YES. You can declare only 10000 (Ten Thousand) Local variables within a Scope.

2. You can Prove.... Try...

DECLARE @nvarDynamic NVARCHAR(MAX),
@intSequence INT

SELECT @nvarDynamic = N'DECLARE ',
@intSequence = 1

WHILE(@intSequence <= 10000)
BEGIN
SELECT @nvarDynamic = @nvarDynamic + N'@COL' + CAST(@intSequence AS VARCHAR) + ' INT,'
SELECT @intSequence = @intSequence + 1
END

SELECT @nvarDynamic = LEFT(@nvarDynamic,LEN(@nvarDynamic)-1)

EXEC(@nvarDynamic)

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Sarvesh, if this helps please login to Mark As Answer. | Alert Moderator

Hi Pandian,

Thanks for the answer and you are good in sql.

Thanks and Regards,
Kumar

Sarvesh, if this helps please login to Mark As Answer. | Alert Moderator