• I am not sure why sql server 2008 returned 1, inspite of not giving the variable length.

    I knew this would give a syntax error, however, I tried this and it returned 1 row.:w00t: