Steffi1013
MIS
When I run sp_who2 active and look at the 'command' field I am seeing many different things including "conditional"
What exactly does "conditional" mean?
What exactly does "conditional" mean?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conditional in sp_who2
- Thread starter Steffi1013
- Start date
- Status
Books Online has the following definition:
So I'm going to assume that "Conditional" means the part of the SQL statement the engine is processing (as in the WHERE clause or a JOIN clause). Of course, this is a wild stab in the dark, so if anyone has any better info, I'd love to hear it.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
BOL said:
So I'm going to assume that "Conditional" means the part of the SQL statement the engine is processing (as in the WHERE clause or a JOIN clause). Of course, this is a wild stab in the dark, so if anyone has any better info, I'd love to hear it.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Thread starter
- #3
Steffi1013
MIS
Can anyone else explain what conditional means?? Is it based on if the sql is doing a conditional statment -- i.e. "if" or "while" ???
If you're asking what conditional literally means, it means "a true/false check for a specific criteria". So, a conditional can be found in an IF...ELSE, WHILE...DO, CASE statement or in WHERE / JOIN / HAVING clauses in T-SQL. You can even have a conditional in a SELECT statement if you're using subqueries in your SELECT.
Does that help?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Does that help?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Thread starter
- #5
Steffi1013
MIS
What I was trying to figure out ... is when it shows up in an sp_who-- what does it mean??
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question