Full text Search in SQL

-

Query

Querying a full-text index is extremely fast and flexible. Because of the specialized index structure described above, it is very quick and easy to locate matches for particular search criteria. 

SELECT ProductModelId, ProductName
FROM ProductModel
WHERE CONTAINS(CatalogDescription, ' " aluminum alloy " ')

USE Northwind;
SELECT FT_TBL.CategoryName
   ,FT_TBL.Description
   ,KEY_TBL.RANK
FROM dbo.Categories AS FT_TBL
   INNER JOIN FREETEXTTABLE(dbo.Categories, Description,
       'sweetest candy bread and dry meat') AS KEY_TBL
       ON FT_TBL.CategoryID = KEY_TBL.[KEY];

score value, because they are predicates in the Transact-SQL language.

Rank values for full-text queries may be returned from CONTAINSTABLE
and FREETEXTTABLE full-text query clauses. CONTAINSTABLE and
FREETEXTTABLE behave like table-valued functions that return two
columns: a key column (which can be used to join to the full-text
indexed base table), and a rank column (which can be used to order
results by rank). The CONTAINS and FREETEXT clauses do not expose a

Comments

Post a Comment

Popular posts from this blog

IBM FileNet: Bulk Processing using JavaScript

-
IBM FileNet: Bulk Processing using JavaScript The IBM FileNet Content Platform Engine server uses the Mozilla Rhino scripting engine to execute the JavaScript. Prerequisites for running the JavaScript examples: Content Platform Engine 5.2.0 or later Downloading document content    This JavaScript example downloads the document content to a specified directory. Because the JavaScript code is executed on a Content Platform Engine server, the content download directory that you specify in the code must exists on the CPE server and should have write permissions  Procedure Open an object store and create an object store search. On the  SQL view  tab, enter the following query: SELECT TOP 100 This FROM Document   Select  Enable bulk action  on the bulk action tab.  In the  Script  section, click  Run script .  Copy the following JavaScript code and paste it into the  Script  field:  im...
Read more

DB2 Date Time Functions

-
https://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html One of the most important database design decisions you will make – for DB2 or any relational DBMS – is to use the proper data types for your columns when building tables. The data type that you choose for each column should be the one that most closely matches the domain of values that the column can be used to store. Indeed, perhaps the most important design choice is to actually use the date/time data types that are available to you; for DB2 this is DATE, TIME, and TIMESTAMP. The ability to store dates as a native DB2 data type is a great advantage. If you need to store date information in your DB2 tables you should favor using the DATE data type instead of forcing a date into some other data type (such as CHAR or DECIMAL). Many a database design has been ruined (in my opinion) because somebody decided to store date data in a CHAR column. When DB2 knows that the data should be a DATE or a TIM...
Read more

File Net Insert Document

-
public static void insertDocument ( Connection conn , String domainName ) { // Get domain. Domain domain = Factory . Domain . fetchInstance ( conn , domainName , null ); ObjectStoreSet osColl = domain . get_ObjectStores (); // Get each object store. Iterator iterator = osColl . iterator (); while ( iterator . hasNext ()) { // Get next object store. ObjectStore objStore = ( ObjectStore ) iterator . next (); // Get the display name of the object store. String objStoreName = objStore . get_DisplayName (); System . out . println ( "Object store name = " + objStoreName ); // Create a document instance. Document doc = Factory . Document . createInstance ( objStore , ClassNames . DOCUMENT ); // Set document properties. doc . getProperties (). putValue ( "DocumentTitle" , "New Document via Java API" ); doc . set_Mi...
Read more