A syntax error - that magically is forgiven my most - but not all - of the SQL Servers - sp_executesq

Question

declare @MSG varchar(200);
declare @stmt nvarchar(2048);
declare @rc integer;
declare @table_name varchar(248)
set @table_name='sys.columns'
set @stmt = N'select @rc=count(*) from '+ @table_name
exec sp_executesql @stmt , N'@rc int output', @rc=@RC OUTPUT
set @MSG ='Records in table ' + @table_name + ' :' + cast(@rc as varchar) ;
select @MSG ;

The syntax is that =@RC is not required, but not always flagged as an error

Answer 1

Well, Thanks.
The solution is .. The code above will fail when the Instance is case sensitive.
It runs OK when the instance is case insensitive.