Professional Web Applications Themes

suspect on sp execution order - Microsoft SQL / MS SQL Server

Hello, friends: If I have a SP with TSQL code as EXEC sp1 EXEC sp2 EXEC sp3 .... where sp1, sp2, sp3 are several stored procedures, am I guaranteed they will be executed sequentially? Or is there some possibility that their execution overlap? Is there some way to control this cirstance? Thanks, Diego Buendia Barcelona, Spain...

  1. #1

    Default suspect on sp execution order

    Hello, friends:

    If I have a SP with TSQL code as

    EXEC sp1
    EXEC sp2
    EXEC sp3
    ....

    where sp1, sp2, sp3 are several stored procedures, am I guaranteed
    they will be executed sequentially? Or is there some possibility that
    their execution overlap? Is there some way to control this
    cirstance?

    Thanks,

    Diego Buendia
    Barcelona, Spain
    DIEGO BUENDIA Guest

  2. #2

    Default Re: suspect on sp execution order

    Stored procedures (or currently any tsql) is executed in a procedural
    fashion. sp1 must finish before sp2 is run and sp2 must finish before sp3.

    --

    Andrew J. Kelly
    SQL Server MVP


    "DIEGO BUENDIA" <DIEGOBBTELELINE.ES> wrote in message
    news:485c6546.0307070519.5a49bce6posting.google.c om...
    > Hello, friends:
    >
    > If I have a SP with TSQL code as
    >
    > EXEC sp1
    > EXEC sp2
    > EXEC sp3
    > ...
    >
    > where sp1, sp2, sp3 are several stored procedures, am I guaranteed
    > they will be executed sequentially? Or is there some possibility that
    > their execution overlap? Is there some way to control this
    > cirstance?
    >
    > Thanks,
    >
    > Diego Buendia
    > Barcelona, Spain

    Andrew J. Kelly Guest

Similar Threads

  1. Controllin "custom web server control" execution order
    By grincik50 in forum ASP.NET Building Controls
    Replies: 0
    Last Post: February 5th, 05:11 AM
  2. sqlserver database suspect
    By Selen in forum ASP.NET Security
    Replies: 1
    Last Post: February 1st, 05:34 AM
  3. action script execution order
    By danpojack webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 4
    Last Post: January 29th, 01:31 PM
  4. Execution order of AS on different layers
    By Batlock webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 7
    Last Post: January 21st, 09:49 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