您要查找的是不是:
- This column may be a regular stored column or a persisted computed column. 该列可以是常规存储列,也可以是持久化计算列。
- Persisted computed columns require the following SET options to be set as shown in the previous section "Required SET Options for Indexed Views". 持久化计算列需要将以下SET选项设置为在上一部分“索引视图所需的SET选项”中显示的内容。
- Creating Indexes on Persisted Computed Columns 为持久化计算列创建索引
- Functions might be imprecise if the computed column is PERSISTED. 如果计算列是PERSISTED,则函数可能不精确。
- The column is a computed column. 该列是计算所得的列。
- Not a computed column or view column. 非计算列或视图列。
- The computed column can be indexed in the usual way. 可以按通常的方式对计算列创建索引。
- You tried to set a default value on a computed column. 您曾试图为计算列设置默认值。
- CHECK constraints on computed columns must also be marked PERSISTED. 计算列上的CHECK约束也必须标记为PERSISTED。
- By marking a computed column as PERSISTED, you can create indexes on computed columns defined on expressions that are deterministic, but not precise. 通过将计算列标记为PERSISTED,可以对确定(但不精确)的表达式中定义的计算列创建索引。
- How do I determine if a column is used in a computed column expression? 如何确定某列是否在计算列表达式中使用?
- As a side effect, the statement adds a computed column desc_ru to the table. 该语句有一个副作用,向表中添加一个计算列desc_ru。
- NOT NULL can be specified for computed columns only if PERSISTED is also specified. 只有同时指定了PERSISTED时,才能为计算列指定NOT NULL。
- Such a failure may take place when the computed column results in arithmetic error. 当计算列导致算术错误时可能产生这样的失败。
- XML instances can appear as a source for a computed column, or as a type of computed column. XML实例可作为计算列的源或计算列的类型出现。
- This change in behavior affects only the data type of the computed column but not the computed value. 这一行为更改只影响计算列的数据类型,而不影响计算值。
- The function name is then specified in the CREATE TABLE statement for the computed column. 然后在CREATE TABLE语句中为计算列指定函数名称。
- Specifies either an alternate name for a column or the name you can use for a computed column. 指定列的替换名,或者用户可以用于计算列的名字。
- For example, non-deterministic computed columns cannot be indexed. 例如,不能对不确定的计算列进行索引。
- However, computed columns cannot be used in this context. 但是,计算列不能用于此上下文。