Nice question.However it will fetch error in SQL 2005 not sure about upper version as we can not assign value while declaration.