• 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