SQLFiddle: must declare the scalar variable error

Question

I'm trying to execute next SQL statement (SQL Server 2008 Profile)

DECLARE @fun int;
SET @fun = 40;

select cast(@fun as varchar(10)) + 'hello'

and SQLFiddle gives me the error: Must declare the scalar variable @fun

Where I'm wrong?

http://sqlfiddle.com/#!3/d41d8/42156

Answer 1

I think the semicolons are introducing the problem here.

As described here: http://www.sql-server-helper.com/error-messages/msg-137.aspx and here: SQL Server - Variable declared but still says "Must declare the scalar variable", the problem arises when the statements are executed individually instead of as a “unit”, and the semicolons seem to trigger that.

When I remove the semicolons from your statement, it works: http://sqlfiddle.com/#!3/d41d8/42159