Professional Web Applications Themes

Question on bcp - Microsoft SQL / MS SQL Server

If I am using bcp to queryout an sp any temp table in the sp would have to be a global temp table or can it be regular temp tables? thanks Meenal...

  1. #1

    Default Question on bcp

    If I am using bcp to queryout an sp any temp table in the sp would have to
    be a global temp table or can it be regular temp tables?

    thanks
    Meenal


    Meenal Guest

  2. #2

    Default Re: Question on bcp

    It would have to be global - unless it was created by the bcp session - and
    I've never heard of anyone even trying that...

    HTH,
    Tore.

    "Meenal Dhody" <com> wrote in message
    news:phx.gbl... 


    Tore Guest

  3. #3

    Default Re: Question on bcp

    The scope of local temp tables is the current connection. Since BCP
    runs on a separate connection, local temp tables are not visible on the
    BCP utility. You'll need to use a global temp table or permanent table.

    If you use a global temp table, you'll need to generate a unique name to
    allow concurrent proc execution. A common practice is to add a unique
    suffix, like SPID.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
    http://www.sqlserverfaq.com
    http://www.mssqlserver.com/faq
    -----------------------

    "Meenal Dhody" <com> wrote in message
    news:phx.gbl... 
    have to 


    Dan Guest

Similar Threads

  1. Newbie Question: Biz Card Template Question
    By Thomas_Porter@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: May 30th, 08:08 AM
  2. Replies: 9
    Last Post: April 27th, 04:44 AM
  3. Pen Tool Use Question. (Embarrassingly Newbie Question)
    By Bozo Schmozo in forum Macromedia Flash
    Replies: 0
    Last Post: November 12th, 10:00 PM
  4. regexp question + html::pr question on the side
    By boris in forum PERL Miscellaneous
    Replies: 4
    Last Post: September 27th, 02:24 AM
  5. newB question: related tables question
    By Blue man in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 04:13 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