using case in select statement

You cannot use the switch statement in ASP, you need to use the Select Case statement A Brief introduction Select the work of the report, if the statement. The difference, however, is that they can check for multiple values. Of course, you

Case has two formats. Simple case function and case search function.--Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' END --case search function case If sex = ' 1 ' Then ' man ' When sex = ' 2 '

This section describes how to use C # To select control statements. The third lesson will achieve the following purposes:1. Learn how to use the "if" statement. 2. Learn how to use the "switch" statement. 3. Learn how to use the "break" statement in

One way to "make something happen" is to evaluate an expression with a side effect. Injected assignments and function calls these expressions with side-effects can be used as separate statements, and this expression is also called an expression

I. Shell Condition Statement (if usage) If statement structure [if/then/Elif/else/FI] If condition test statement Then Action [Elif Condition Action Else Action ] Fi If you are not clear about the conditional test statement, refer to:

Address: http://www.ibm.com/developerworks/cn/rational/r-usecase-atm/index.html Level: elementary Fu chunyi, technical sales manager of Rational China, software department of IBM China Co., Ltd. November 01, 2004 Use Case is a method used to

Basics of T-sql: Beyond basic Level 6: Using case expressions and IIF functionsGregory larsen,2016/04/20 (First edition: 2014/04/09)The seriesThis article is part of "Stairway series: The cornerstone of T-sql: Beyond the Basics"From his stairway to

Case modeling GuideFu chunyi, technical sales manager of rational China, software department of IBM China Co., Ltd.November 01, 2004Original URL: http://www-128.ibm.com/developerworks/cn/rational/r-usecase-atm/@

Use case is a method used to describe system requirements. The process of describing system requirements using use cases is case modeling. The use case method was first proposed by Dr. IVA jackboson and was later integrated into the UML

SQL statement case when then else end returns a qualified value, sqlcase Case has two formats Simple Case functions and Case search functions: -- Simple Case function CASE sex WHEN '1' then' male 'when' 2' then' female 'else' other 'ends -- Case