|
Home > Archive > Microsoft SQL Server forum > June 2005 > Conditional -- ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jim_geissman@countrywide.com 2005-06-27, 1:23 pm |
| What does "conditional" mean as a command? sp_who2 reports this for
some sessions, along with "insert" etc.
Thanks,
Jim Geissman
| |
| Erland Sommarskog 2005-06-27, 8:23 pm |
| (jim_geissman@countr
ywide.com) writes:
> What does "conditional" mean as a command? sp_who2 reports this for
> some sessions, along with "insert" etc.
An IF or WHILE statement. Typically with a query in the condition, like
IF EXISTS(SELECT ...). If this query is long-running, or the longest
running in a stuck loop, CONDITIONAL is likely to turn up.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
| jgeissman@socal.rr.com 2005-06-29, 8:24 pm |
| Thanks, Erland!
Erland Sommarskog wrote:
> (jim_geissman@countr
ywide.com) writes:
>
> An IF or WHILE statement. Typically with a query in the condition, like
> IF EXISTS(SELECT ...). If this query is long-running, or the longest
> running in a stuck loop, CONDITIONAL is likely to turn up.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
|
|
|
|
|