statement column 中文意思是什麼
statement column
解釋
語句列-
In create table statement to use the space saving row format at the column or table level to reduce space required for a table
，可以在列或表級別上使用節省空間的行格式來減少空間佔用。 -
The following table describes the supported column types and the output from the statement
下表說明了所支持的列類型和該語句的輸出結果。 -
Transact - sql keywords that control the flow of execution of sql statements and statement blocks in triggers, stored procedures, and batches. correlated subquery a subquery that references a column in the outer statement
在sql api中，綁定可使結果集列或參數與程序變量相關聯，以便在提取或更新行時自動將數據移入或移出程序變量。 -
If an update to a row violates a constraint or rule, violates the null setting for the column, or the new value is an incompatible data type, the statement is canceled, an error is returned, and no records are updated
如果對行的更新違反了某個約束或規則，或違反了對列的null設置，或者新值是不兼容的數據類型，則取消該語句、返回錯誤並且不更新任何記錄。 -
Explicit column names in the select statement
在select語句中顯式指定列名。 -
To ensure that only 10 rows are deleted, the column specified in the subselect statement
為了確保僅刪除10行，嵌套select語句（ -
Using a nonkey column in the subselect statement may result in the deletion of more than 10 rows if the specified column contains duplicate values
如果指定列包含重復的值，則在嵌套select語句中使用非鍵列可能會導致刪除的行超過10個。 -
The case statement concatenates the firstname, middlename, and lastname columns into a single column that you will use in the customer dimension as the displayed name for the customer attribute
Case語句將firstname 、 middlename和lastname列串聯為一個列，該列將在客戶維度中用作客戶屬性的顯示名稱。 -
The delete statement is provided all primary key column values
為delete語句提供所有主鍵列值。 -
The insert statement does not need to specify the value for the serialnumber column
Insert語句不需要指定serialnumber列的值。 -
Statement to skip to the next column of an array if a divisor is zero
語句在除數為零時跳到數組的下一列。 -
Column in a create view statement, an alter view statement can name the
列上的權限，則alter view語句可以將 -
This statement cannot be used to modify the index definition, such as adding or deleting columns or changing the column order
此語句不能用於修改索引定義，如添加或刪除列，或更改列的順序。 -
Insert statement would change to include the new column
插入語句將發生變化以包括新列。 -
If a null parameter value is passed and that parameter is used in a create table or alter table statement in which the referenced column does not allow null values, the database engine generates an error
如果傳遞null參數值並且在create或alter table語句中使用該參數，而該語句中被引用列又不允許使用空值，則數據庫引擎會產生一個錯誤。 -
Additionally, when the select statement includes a union operator, the column names or column aliases must be those specified in the first select list
此外，當select語句包含union運算符時，列名或列的別名必須是在第一選擇列表內指定的列名或列的別名。
分享友人