Post reply

Problem while executing Query batch

  • July 14, 2009 at 4:53 am

    #73935

    Im running batch of query using c# code.

    each query is seperated by(;). When i excecute some deadlock type condition occurs.

    Batch can be anything like

    select * from tbl1;Update tbl2...; declare cursor... etc

    So can we stop execution of batch if this contains (;)

  • July 14, 2009 at 5:56 am

    #1024337

    Instead of running batch of query using C# code,

    create a stored procedure with all these queries and call the stored procedure from the C# code.

  • July 14, 2009 at 9:04 am

    #1024463

    triple post.

    please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply