Professional Web Applications Themes

table variable vs temptable - Microsoft SQL / MS SQL Server

Is there any performance/any other advantage of using a table variable over temptable. Thanks....

  1. #1

    Default table variable vs temptable

    Is there any performance/any other advantage of using a
    table variable over temptable.

    Thanks.

    sam Guest

  2. #2

    Default Re: table variable vs temptable

    Sam ,
    performance is the big one as variable tables are always in memory


    --
    I hope this helps
    regards
    Greg O MCSD
    http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Doentation
    Builder, the quickest way to doent your database
    http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
    Property Extended properties manager for SQL 2000
    http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
    program
    http://www.ag-software.com. Free programming tools

    "sam" <com> wrote in message
    news:023001c36a9f$6d22b000$gbl... 


    Greg Guest

  3. #3

    Default Re: table variable vs temptable

    Here's MS answer...
    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q305977



    --
    -oj
    Rac v2.2 & QALite!
    http://www.rac4sql.net


    "sam" <com> wrote in message
    news:023001c36a9f$6d22b000$gbl... 


    oj Guest

  4. #4

    Default Re: table variable vs temptable

    Sam,

    Should I use a #temp table or a table variable?
    http://www.aspfaq.com/show.asp?id=2475


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "sam" <com> wrote in message
    news:023001c36a9f$6d22b000$gbl... 


    Dinesh.T.K Guest

Similar Threads

  1. query problem, #temptable
    By mail4u9999@yahoo.com in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: August 22nd, 04:27 AM
  2. Is there any way to loop a temp table or table variable without cursor?
    By Lawrence in forum Microsoft SQL / MS SQL Server
    Replies: 7
    Last Post: August 9th, 08:25 PM
  3. SP with Table name as Variable
    By Jonesgj in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 19th, 08:18 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139