Select the work of the report, if the statement. The difference, however, is that they can check for multiple values. Of course, you have
Many of the same, if. Else statement, but this is not always the best method.
The SELECT statement allows a
When we make choice judgment, we usually use the IfElse method, but it is not suitable when the condition of judgment is more.We usually use Select Case method to make choice judgment.The SELECT statement allows a program to evaluate the expression
Select Case is a condition to choose his advantage is the only export, a lot of time he is much better than if else oh.example18Select1%>
The syntax for the SELECT statement is as follows:Select Case ExpressionCase Label_1Statements_1Case
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
First, Select case syntax and parameter introduction
Select Case testexpression
[Case Expressionlist-n
[Statements-n]] ...
[Case Else
[Elsestatements]]
End Select
The syntax for the Select case statement has the following sections:
Overview:The case statement in the SQL statement and the switch statement in the high-level language are standard SQL syntax, and are suitable for a condition that has multiple values to perform different operations, respectively.First, let's look
If syntax:if [expression]ThenCommandselif [Expression2]ThenCommandsElseCommandsFiCase Syntax: Case string1 inSTR1)commands;;STR2)commands;;*)Commans;;EsacLoop statement for syntax: for Var in listDoCommands done In this form, for each item in the
select| syntax
The most commonly used command in SQL is the SELECT statement, which is used to retrieve data. The syntax is:
SELECT [All | DISTINCT [On (expression [, ...]]]] * | expression [as Output_name] [, ...] [INTO [temporary | TEMP] [TABLE]
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.