Professional Web Applications Themes

Batch Inserts - Microsoft SQL / MS SQL Server

Is there a way to implement a batch INSERT. Currently in my asp.net code I perform a loop. As each loop runs through I construct my Insert command and execute it through ado.net. I was just wondering if you can construct some sort of a batch INSERT command. Mabey pass an array or hash of information as a parameter to a stored proc. Then in SQL (if possible) loop through and perform querys. Any Ideas? Thanks, Ron Vecchi...

  1. #1

    Default Batch Inserts

    Is there a way to implement a batch INSERT.

    Currently in my asp.net code I perform a loop. As each loop runs through I
    construct my Insert command and execute it through ado.net.

    I was just wondering if you can construct some sort of a batch INSERT
    command. Mabey pass an array or hash of information as a parameter to a
    stored proc. Then in SQL (if possible) loop through and perform querys.

    Any Ideas?


    Thanks,

    Ron Vecchi


    Ron Guest

  2. #2

    Default Batch Inserts


    Hi

    The following VYAS Site can be useful for ur scenerio.

    http://vyaskn.tripod.com/passing_arrays_to_stored_procedure
    s.htm

    The information will give an overall idea so that u can
    change according to ur requirement.

    Hey ..Vyas,

    Sorry for postring ur article with out your
    permission..

    HTH
    Rajesh Peddireddy

     
    loop runs through I 
    ado.net. 
    batch INSERT 
    parameter to a 
    perform querys. 
    Rajesh Guest

  3. #3

    Default Re: Batch Inserts

    In addition to the article by Vyas, Erland also has an article on this:
    http://www.algonet.se/~sommar/arrays-in-sql.html

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

    "Ron Vecchi" <net> wrote in message
    news:phx.gbl... 
    through I 

    querys. 


    Dan Guest

Similar Threads

  1. Looping CF inserts
    By tthrone@frontiernet.net in forum Coldfusion Database Access
    Replies: 3
    Last Post: November 22nd, 11:16 PM
  2. 1-to-Many Inserts
    By Fandomlife in forum Macromedia ColdFusion
    Replies: 3
    Last Post: March 29th, 09:15 PM
  3. need loop that INSERTS into same row
    By Greggg in forum Macromedia ColdFusion
    Replies: 2
    Last Post: March 21st, 01:21 PM
  4. CLOB Inserts
    By cfcoder2 in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 8th, 09:51 PM
  5. Batch Processing, not quite batch
    By Ken_Blesse@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: May 19th, 02:03 PM

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