Problem while executing Query batch

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Problem while executing Query batch

Problem while executing Query batch

Rate Topic

Display Mode

Topic Options

Author

Message

harendra.singh

Posted Tuesday, July 14, 2009 4:53 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 01, 2011 3:14 AM
Points: 11, Visits: 45

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 (;)

Post #752570

Suresh B.

Posted Tuesday, July 14, 2009 5:56 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:54 AM
Points: 1,076, Visits: 5,128

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.

Post #752598

LutzM

Posted Tuesday, July 14, 2009 9:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 12:04 PM
Points: 6,739, Visits: 12,167

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
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function

Post #752748

« Prev Topic | Next Topic »

Permissions