选择差异(“跳蚤"，“羊毛")是什么意思 [英] SELECT DIFFERENCE ( 'Fleas', 'Fleece') what does it mean

问题描述

SELECT DIFFERENCE(``Fleas''，``Fleece'')此查询的含义

SELECT DIFFERENCE ( ''Fleas'', ''Fleece'') what is the meaning of this query

推荐答案

这是非常好的Transact-SQL函数，这会通过给定sonsondex值来返回您的一个interger.
返回值的范围是0到4，其中0表示很少或没有相似性，而4表示强相似性或相同值.

it is very nice transact-SQL function, which will return you an interger by camparing sondex value.
The return value ranges from 0 to 4 where 0 indicates little or no similarity, and 4 indicates strong similarity or identical values.

将两个字符表达式的SOUNDEX值之间的差作为整数返回. . (4是可能的最小差异，0是最大的差异)
http://msdn.microsoft.com/en-us/library/aa258844 (v = sql.80).aspx [

Returns the difference between the SOUNDEX values of two character expressions as an integer. (4 is the least possible difference and 0 is the highest)
http://msdn.microsoft.com/en-us/library/aa258844(v=sql.80).aspx[^]

这篇关于选择差异(“跳蚤"，“羊毛")是什么意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！