rhythm.varshney (12/10/2012)
Nice question.However it will fetch error in SQL 2005 not sure about upper version as we can not assign value while declaration.
2005 has been off of mainstream support for over a year, not accounting for it anymore seems pretty standard.