Temp Table

  • Nitin Bhargava

    SSCarpal Tunnel

    Points: 4190

    Comments posted to this topic are about the item Temp Table

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    Easy one ..... +1

  • Neeraj Prasad Sharma

    Ten Centuries

    Points: 1285

    Lovely Tuesday morning 1+,

    Back to BASIC...

    Neeraj Prasad Sharma
    Sql Server Tutorials

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    Easy and good basic question. 🙂

    Sometimes its good to play around basic. Its refresh us. 🙂

    Thanks

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • demonfox

    SSCertifiable

    Points: 6289

    easy one.

    In case of global temporary table creation it will throw an error. i.e ##Table1

    Local Temp just gets another session.

    Thanks for the question.

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • Lokesh Vij

    SSChampion

    Points: 10836

    demonfox (6/25/2013)


    easy one.

    In case of global temporary table creation it will throw an error. i.e ##Table1

    Local Temp just gets another session.

    Thanks for the question.

    Good point..

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • kapil_kk

    SSC-Insane

    Points: 21316

    Danny Ocean (6/24/2013)


    Easy and good basic question. 🙂

    Sometimes its good to play around basic. Its refresh us. 🙂

    Thanks

    +1 :-):-P

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • malleswarareddy_m

    SSCertifiable

    Points: 5847

    Easy one

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • begin.b4u

    Default port

    Points: 1451

    Its temporary table creation

  • Tock

    Default port

    Points: 1432

    Perfect question for the morning after a night with little sleep 🙂

    Cheers,

    Steve

  • DugyC

    Hall of Fame

    Points: 3804

    Tock (6/25/2013)


    Perfect question for the morning after a night with little sleep 🙂

    Cheers,

    Steve

    Unless you didn't read the question properly and skimmed the part about opening another query window... doh! :doze:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • sathikothapalli

    Newbie

    Points: 7

    Easy one.

  • Revenant

    SSC-Forever

    Points: 42467

    Interesting and easy - thanks!

  • Ken Wymore

    SSCoach

    Points: 16514

    I was looking for the trick in this question and was thankful that there wasn't one. Nice question on a basic function.

  • Bangla

    Hall of Fame

    Points: 3137

    Fine....

Viewing 15 posts - 1 through 15 (of 21 total)

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