您要查找的是不是:
- 您的應用程序對XML列執行數據檢索,并且不需要XML列的XML索引。Your application performs data retrieval on the XML column and does not require an XML index on the XML column.
- 對XML列的全文索引Full-Text Index on an XML Column
- XML列可以用于XML索引中The XML column can be used in an XML index
- SQL Server中的全文搜索現在支持對XML數據類(lèi)型創(chuàng )建全文索引以及對其進(jìn)行全文查詢(xún)。Full-text search in SQL Server now supports the creation of full-text indexes on, and full-text queries against, the XML data type.
- 以下SQL視圖定義對關(guān)系列pk和從XML列中檢索到的書(shū)作者創(chuàng )建XML視圖The following SQL view definition creates an XML view over a relational column, pk, and book authors retrieved from an XML column
- 以下示例將返回名為Cat_Desc的全文目錄中的全文索引項數目。The following example returns the number of full-text indexed items in a full-text catalog named Cat_Desc.
- 查詢(xún)類(lèi)型化的xml列或變量時(shí),可以包含布爾類(lèi)型的節點(diǎn)。When querying typed xml columns or variables, you can have nodes of Boolean type.
- 可以從XML列中搜索目標郵政編碼,并相應地限制返回的結果集。You can search the XML column for the target zip code and restrict the returned result set accordingly.
- 指定在數據庫分離操作過(guò)程中不會(huì )刪除與正在被分離的數據庫關(guān)聯(lián)的全文索引文件。Specifies that the full-text index file associated with the database that is being detached will not be dropped during the database detach operation.
- 請接受我們對你及你全家的美好祝福,祝你們新年快樂(lè )。Please accept our wishes for you and yours for a happy New Year.
- 如果WITH子句中的列是類(lèi)型化的XML列并且XML實(shí)例不符合架構,將返回錯誤。In case the column in the WITH clause is a typed XML column and the XML instance does not confirm to the schema, an error is returned.
- 您可以配置的功能之一是希望對XML數據強制的一致性級別。One of the features that you can configure is the level of conformance you wish to enforce on the XML data.
- 如何從表中刪除全文索引(SQL Server Management Studio)How to: Remove a Full-Text Index from a Table (SQL Server Management Studio)
- 通過(guò)對這些的研究,我們了解了大量有關(guān)地球的內部情況。It was from the study of these that so much was learnt about the interior of the earth.
- 搜索以基于字符的指定文本、字詞或短語(yǔ)為前綴的列的全文查詢(xún)。Full-text query searching for those occurrences where the specified words are close to one another.
- 還需要對XML有一定了解,至少能閱讀和手工編寫(xiě)XML文件。You also need to understand XML at least to the extent of being able to manually read and write XML files.
- "可是對你來(lái)說(shuō)這是一樁大事啊。" "什么大事不大事的!我擔心什么?""But it's a serious matter for you." "Serious my foot, why should I worry?"
- 闡明了全文索引也可應用于索引視圖。Clarified that full-text indexes can also be applied on indexed views.
- 選擇“是”將繼續操作并禁用該列的全文搜索。Choose Yes to proceed with the operation and disable full-text searches of this column.
- “App_Data”文件夾具有的權限允許網(wǎng)頁(yè)對XML文件進(jìn)行讀寫(xiě)數據的操作。The App_Data folder has permissions set on it that will allow the Web page to read and write data to the XML file.