How to run 2 queries in same connections.

From: ςΡΒΙΓΛΙΚ εΧΗΕΞΙ (eryabitski..iasoft.ru)
Date: Tue Jan 12 2010 - 03:08:55 EST

  • Next message: Andrus Adamchik: "Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries"

    Hello 2 everyone!

     

    I have one potential problem:

     

    We have stored procedure on MS SQL Server. It's doing some job and return result in special table marked with connection id ..SPID).

     

    So next query is to get result: SELECT * FROM SpecTable WHERE spid = ..PID

     

    So these 2 queries should be in same connection (to have same..SPID).

     

    In first solution there was huge transaction wrapping around this 2 queries and I think there was same connection.

    But for performance proposes I can't use one huge transaction, so I switched to explicit transaction (to not have any transaction).

    Now I am not sure how to make sure that these queries are performed in same connections???

     

    Evgeny.

     

    This archive was generated by hypermail 2.0.0 : Tue Jan 12 2010 - 03:16:43 EST