Results 1 to 2 of 2

Thread: Tempory tables

  1. #1
    Join Date
    Mar 2008

    Unanswered: Tempory tables

    In interview there was a question :- How many tempory table in database.

    any answer?

  2. #2
    Join Date
    May 2008

    RE: Tempory tables

    I think the question should be
    How many types of temporary tables are there is ( sybase ) database.

    If this is the case then ....

    Hash ( # ) tables :
    Accessible from user database, though created in tempdb.
    Available till connection session expires.

    create table #sample_hash
    ( col1 )

    Temporary tables :
    Accessible from tempdb database
    Available till server gets rebooted.

    create table tempdb..sample_table
    ( col1 )


Posting Permissions

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