default temproary tables in SQL Server

• sumit.malik

  SSC Journeyman

  Points: 97

  More actions

  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.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  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.