---- Local Temp Table 
      CREATE TABLE dbo.#myLocalTempTable
      (
        ID    int      NOT NULL,
        Name  char(10) NULL
      )
      
      
      
 ---- Global Temp Table 
      CREATE TABLE dbo.##myGlobalTempTable
      (
        ID    int      NOT NULL,
        Name  char(10) NULL
      )
      GO