Declare @local variable

  • Revenant

    SSC-Forever

    Points: 42467

    Makes for tidier code, IMO. Thanks for the question, Steve!

  • Narud

    SSCrazy

    Points: 2819

    Finally an easy question!

    Thanks!

    😀

  • TomThomson

    SSC Guru

    Points: 104772

    philip.cullingworth (12/5/2013)


    Mr. Kapsicum (12/4/2013)


    easy one for the guys who has past experience in 2005 😀

    And those with current experience of 2005:-)

    And for those with no experience of 2005 who noticed the fanfares when this was announced for 2008. 😀

    Tom

  • SQLRNNR

    SSC Guru

    Points: 281210

    Revenant (12/5/2013)


    Makes for tidier code, IMO. Thanks for the question, Steve!

    Agreed - thanks:hehe:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • PChiragS

    SSCarpal Tunnel

    Points: 4965

    didn't need to think a second for the answer...

    easy one ..

    thanks steve

  • Hany Helmy

    SSChampion

    Points: 13321

    Very easy one, already had a previous experience with this before.

  • Amit Raut

    SSCrazy

    Points: 2613

    OCTom (12/5/2013)


    The first SQL server version I worked with was 2000. I got into the habit of declaring and setting in two statements and I still do that today. I forgot you can declare and set in one statement. :crazy:

    Tom

    Me too 😉

  • Rich Mechaber

    SSChampion

    Points: 10935

    Finally - continued use of an older SQL release earns me easy points on QotD!

    Rich

  • sqlnaive

    SSCoach

    Points: 17435

    Pretty easy one. 🙂

  • jfgoude

    SSCrazy

    Points: 2586

    easy one

    +1

    just had a fear of a trick due to the maybe opt !!

Viewing 10 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply