Jay Johengen Altamahaw-Ossipee, Caroline du Nord, États-Unis
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Conditional Logic
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01324772
Message ID:
01324772
Vues:
52
I need to do something like the following in a query.
DO WHILE looping through fetched rowsand @MyVar changes value
BEGINIF @MyVar = 1BEGIN
Do This
ENDIF @MyVar > 1BEGIN
Do This
ENDIF @MyVar = 1and there were no @MyVar > 1BEGIN
Do This
ENDEND