SQL Temp. Tables

• SQL Espo

  SSCrazy

  Points: 2678

  More actions

  October 28, 2004 at 7:05 am

  #84490

  Can anyone issue create table statements for SQL Server temp. tables (the ones that start with the # sign)?

• Ashok-148808

  SSC Veteran

  Points: 247

  More actions

  October 28, 2004 at 9:41 pm

  #528362

  SQL Temp Table Creation :

  CREATE TABLE #temptable (Details Varchar(50), Monthname  Varchar(15), Qty decimal, Value decimal(18,2), Companyid varchar(10), Closingflag numeric, Sno numeric, Head numeric)

  Hope this be helpful.

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 28, 2004 at 11:54 pm

  #528365

  Yes, every user has permissions to create temporary tables.

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

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  October 29, 2004 at 12:29 pm

  #528433

  Unless you restrict them from tembdb yes?

  Wes