Post reply

SQL Temp. Tables

  • 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)?

  • 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.

     

  • 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]

  • October 29, 2004 at 12:29 pm

    #528433

    Unless you restrict them from tembdb yes?

    Wes

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

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