nulls
常考释义
Char and binary columns that do not allow nulls are always padded to the length of the column.
始终将不允许为空的char和binary列填充到列长。
Since the requirement is to only suppress nulls, the visual null suppression can be replaced by the Null suppression on the actual query.
因为需求是仅抑制nulls,可视的nullsuppression可由实际查询上的Nullsuppression替换。
Note that this setting is independent of the nulls setting in the columns contained in the foreign key.
注意该设置与外键中所包含列的nulls设置无关。
Add table columns , and specify the column name and data type of the new column, as well as whether the column allows nulls .
添加表列,指定列名和新列的数据类型以及该列是否允许空值。
Define a primary key to enforce uniqueness for values entered in specified columns that do not allow nulls .
定义主键可以对在不允许空值的指定列中输入的值强制唯一性。
The ANSI_NULLS option must have been set to ON for the execution of all CREATE TABLE statements that create tables referenced by the view.
要执行所有CREATETABLE语句以创建视图引用的表,ANSI_NULLS选项必须设置为ON。
Analysis Services ignores nulls when calculating the maximum value in a set of numbers.
计算一组数值的最大值时,AnalysisServices将忽略空值。
The bcp command and BULK INSERT statement both allow you to specify that nulls values be retained.
bcp命令和BULKINSERT语句都允许指定保留空值。
RPG uses a 1 character field (like an indicator) to determine if a column contains nulls.
RPG使用一个1字符字段(比如一个指示符)来确定列是否包含空值。
The aggregate uses custom serialization, has a maximum size of 8000 bytes when serialized, and is invariant to nulls, duplicates, and order.
该聚合使用自定义序列化,在进行序列化时具有8000字节的最大大小,且与空值、重复值和顺序无关。
If SET ANSI_NULLS is not specified, the setting of the ANSI_NULLS option of the current database applies.
如果未指定SETANSI_NULLS,则应用当前数据库的ANSI_NULLS选项设置。
To edit this property, click the Allow Nulls checkbox corresponding to the column in the top pane of Table Designer.
若要编辑此属性,请在表设计器的顶部窗格中单击与列对应的“允许空值”复选框。
New columns defined without explicit nullability do not allow nulls.
未显式定义为空性的新列不允许使用空值。
If the column is NULLABLE, any number of NULLs can be inserted in that column.
如果此列可以包含NULL值,就可以在此列中插入任意数量的NULL值。
The ANSI_NULLS and QUOTED_IDENTIFIER options must have been set to ON when the CREATE VIEW statement was executed.
当执行CREATEVIEW语句时,ANSI_NULLS和QUOTED_IDENTIFIER选项必须设置为ON。
That code would have created a new trail with a Trail object with nulls for all attributes.
这个代码应当创建一条新路线,该路线有一个所有属性都为null的Trail对象。
For each database column, the grid displays its fundamental attributes: column name, data type, and nulls-allowed setting.
对于每个数据库列,该网格显示其基本属性:列名、数据类型和允许空值设置。
Literals represent fixed values - numbers, character strings, booleans, or nulls.
文字表示固定的值数字、字符、字符串、布尔型或空值。
For this report run only nulls are being suppressed on both the row and column edge of the crosstab.
对于该报表运行,仅在交叉表的行和列边缘上抑制了nulls。
When SET ANSI_NULLS is ON, an operator that has one or two NULL expressions returns UNKNOWN.
当SETANSI_NULLS为ON时,带有一个或两个NULL表达式的运算符返回UNKNOWN。
以上图片仅供学习交流使用,版权归原作者所有,如有侵权,请与我方联系