Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Denver,co
    Posts
    8

    Unanswered: Temporary tables

    Can anyone tell me why temp tables usage is significant? How do we create the temp tables(syntax). Are there any session dependent/independent temp tables.

    I really appreciate your help.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: Temporary tables

    Originally posted by anilc
    How do we create the temp tables(syntax). Are there any session dependent/independent temp tables.
    Session dependant : create table #t (i int, c char(3),...)
    Session independant : create table tempdb..t(i int, c char(3),...)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •