SQLServerVideos.com Member Profile for Fredy Muñoz

Member Details

Display Name: Fredy Muñoz
Name: Fredy Muñoz
Location: Guatemala
Web Site: <NULL>

Member Statistics

Joined: December 14, 2011
Total Comments: 0
Last Comment: December 14, 2011

Member Bio

<NULL>



Recent Member Comments by Fredy Muñoz

Hi there,

I believe there is an error in the query displayed at 2:38.

DECLARE @value2 int
SELECT @value = -1

I think it should be:

DECLARE @value2 int
SELECT @value2 = -1
^

This explains why the second column of the SELECT statement is NULL. @value2 is never initialized while @value is given a value of -1.

Am I right?

SQL Server 2008 T-SQL Enhancements on 2011-12-14