您要查找的是不是:
- 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 為持久化計算列創(chuàng )建索引
- 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. 可以按通常的方式對計算列創(chuàng )建索引。
- 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. 通過(guò)將計算列標記為PERSISTED,可以對確定(但不精確)的表達式中定義的計算列創(chuàng )建索引。
- 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. 該語(yǔ)句有一個(gè)副作用,向表中添加一個(gè)計算列desc_ru。
- NOT NULL can be specified for computed columns only if PERSISTED is also specified. 只有同時(shí)指定了PERSISTED時(shí),才能為計算列指定NOT NULL。
- Such a failure may take place when the computed column results in arithmetic error. 當計算列導致算術(shù)錯誤時(shí)可能產(chǎn)生這樣的失敗。
- XML instances can appear as a source for a computed column, or as a type of computed column. XML實(shí)例可作為計算列的源或計算列的類(lèi)型出現。
- This change in behavior affects only the data type of the computed column but not the computed value. 這一行為更改只影響計算列的數據類(lèi)型,而不影響計算值。
- The function name is then specified in the CREATE TABLE statement for the computed column. 然后在CREATE TABLE語(yǔ)句中為計算列指定函數名稱(chēng)。
- Specifies either an alternate name for a column or the name you can use for a computed column. 指定列的替換名,或者用戶(hù)可以用于計算列的名字。
- For example, non-deterministic computed columns cannot be indexed. 例如,不能對不確定的計算列進(jìn)行索引。
- However, computed columns cannot be used in this context. 但是,計算列不能用于此上下文。