IfStatement 型別公開下列成員。方法展開資料表 名稱說明 Accept Accepts the visitor. (覆寫 TSqlFragment.Accept(TSqlFragmentVisitor)。) AcceptChildren Accepts the visitor for Children. (覆寫 TSqlStatement.AcceptChildren(TSqlFragmentVisitor)。) Equals (繼承自 Object。) Finalize (繼承自 Object。) Get...
初始化IfStatement類別的新執行個體。 命名空間:Microsoft.Data.Schema.ScriptDom.Sql 組件:
public TSqlStatement ElseStatement { get; set; } 属性值类型:Microsoft.Data.Schema.ScriptDom.Sql.TSqlStatement 返回一个 TSqlStatement。.NET Framework 安全性对直接调用方的完全信任。此成员不能由部分信任的代码使用。有关更多信息,请参见通过部分受信任的代码使用库。请参见参考...
Executes a statement if the condition is true. Syntax Másolás IF expression THEN assignment END IF Arguments expression A Multidimensional Expressions (MDX) expression that evaluates to a Boolean that returns true or false. assignment An MDX expression that assigns a value to either a subcube...
syntaxsql 복사 IF boolean_expression { sql_statement | statement_block } [ ELSE { sql_statement | statement_block } ] 인수boolean_expression반환 TRUE 하거나 FALSE. boolean_expression 문이 포함된 SELECT 경우 문을 SELECT 괄호로 묶어야 합니다....
syntaxsql Copy IF boolean_expression { sql_statement | statement_block } [ ELSE { sql_statement | statement_block } ] Arguments boolean_expression An expression that returns TRUE or FALSE. If the Boolean expression contains a SELECT statement, the SELECT statement must be enclosed in parenthes...
syntaxsql IFboolean_expression{sql_statement|statement_block} [ELSE{sql_statement|statement_block} ] 参数 boolean_expression 返回TRUE或FALSE. 如果布尔表达式包含语句SELECT,则必须将SELECT语句括在括号中。 { sql_statement | statement_block } 使用语句块定义的任何 Transact-SQL 语句或语句分组。 除非使用了...
syntaxsql IFboolean_expression{sql_statement|statement_block} [ELSE{sql_statement|statement_block} ] 参数 boolean_expression 返回TRUE或FALSE. 如果布尔表达式包含语句SELECT,则必须将SELECT语句括在括号中。 { sql_statement | statement_block } 使用语句块定义的任何 Transact-SQL 语句或语句分组。 除非使用了...
SQL 复制 CREATE TABLE TestBatch (ColA INT PRIMARY KEY, ColB CHAR(3)); GO INSERT INTO TestBatch VALUES (1, 'aaa'); INSERT INTO TestBatch VALUES (2, 'bbb'); INSERT INTO TestBatch VALUSE (3, 'ccc'); -- Syntax error. GO SELECT * FROM TestBatch; -- Returns no rows....
SQL 複製 CREATE TABLE TestBatch (ColA INT PRIMARY KEY, ColB CHAR(3)); GO INSERT INTO TestBatch VALUES (1, 'aaa'); INSERT INTO TestBatch VALUES (2, 'bbb'); INSERT INTO TestBatch VALUSE (3, 'ccc'); -- Syntax error. GO SELECT * FROM TestBatch; -- Returns no...