SQL Temp. Tables

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

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

     

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

  • 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