Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators

Top Categories · View All
TSQL Enhancements 28
Discontinued Features 16
SSIS Enhancements 10
SSMS Enhancements 10
Database Engine 10
Database Administration 8
Security 3
Full Text Search 2
DataTime 1
Breaking Changes 1

Browse by Tags · View All
Denali 82
SQL Server 2012 79
SSIS 9
SSMS Enhancements 9
Analytic Functions 8
Usability Enhancements 5
SQL11 4
TSQL 4
Security 3
Database Engine 3
Datetime 3
Query Hints 2
OVER Clause 2
DMV 2
Groups 2
Dynamic Management Functions 2
DMF 2
System stored procedures 2
DBA 2
FTS 2

Browse by Release · View All
All 58
RC0 20
SQL Server 2012 Denali 2
CTP3 2
SQL Server Denali 1

What is new in SQL Server 2012 - Denali

SQL Server 2012 Denali - Full Text Search Enhancements - Customizable ‘NEAR’ operator

Nov 29 2011 7:15AM by Jacob Sebastian   

The NEAR operator in the CONTAINS predicate is improved in SQL Server 2012 (Denali) to allow users to specify distance between two terms.

This allows a user to run queries such as:

SELECT candidate_name 
FROM Candidates
WHERE CONTAINS(
    Resume, 
    'NEAR(("SQL Server", expertise),5, FALSE)'
);

The above query retrieves all resumes containing the term “SQL Server” within no more than 5 words from “expertise”

Read More Have you written a blog post or article related to this feature and want to get them added here? Read More...
Category : Database Administration,Database Engine,Full Text Search
Release : CTP1
Tags : SQL Server 2012, Denali, Full Text Search, FTS, CONTAINS, NEAR


Jacob Sebastian
1 · 100% · 32004
2



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server 2012 Denali - Full Text Search Enhancements - Customizable ‘NEAR’ operator" rated 5 out of 5 by 2 readers
SQL Server 2012 Denali - Full Text Search Enhancements - Customizable ‘NEAR’ operator , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]