Post reply

default temproary tables in SQL Server

  • February 10, 2005 at 10:01 pm

    #87518

    Hi,

     

    Few days back somebody asked me what are the default temproray tables in SQL server 2000 which gets created and destroyed dynamically or something like this? Is the question right or wrong? I'm asking this because I have no clue on this thing.can anybody tell me more about this.

  • February 11, 2005 at 1:38 am

    #541728

    Since your question is not very specific, as a starter you might want to read BOL for CREATE TABLE. There is a whole chapter on temporary tables.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 11, 2005 at 8:48 am

    #541819

    You also may want to look up the "Inserted" and "Deleted" tables in BOL. 

    I wasn't born stupid - I had to study.

Viewing 3 posts - 1 through 2 (of 2 total)

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