sqlserver内置函数-创新互联

function Binary_CheckSum 

对大小写敏感,想忽略大小写可用CheckSum.

创新互联公司是一家专注于成都做网站、网站设计与策划设计,葫芦岛网站建设哪家好?创新互联公司做网站,专注于网站建设十余年,网设计领域的专业建站公司;建站业务涵盖:葫芦岛等地区。葫芦岛做网站价格咨询:18982081108

These functions are also valuable for comparing and indexing long string columns. Instead of creating an index on such column, you can add a column based on

the checksum or binary checksum of the value in the string column and index it instead. This type of index is typically called a hash index. SQL Server will

find matching records by comparing int values instead of comparing long strings, which might provide significant performance improvement.

对于包含长字符串的column，可以在该列值的checksum or binary checksum建索引 ，以代替直接在列值建索引，可提高performance。

------------------------------------------------------------------

function Coalesce()

The Coalesce() function is often used to coalesce (unite) values that are split into several columns. The result of the function is the first non-null expression. This function uses the following syntax:

COALESCE(expression [,...n])

返回参数中第一个non-null值

当前名称：sqlserver内置函数-创新互联
文章路径：http://6mz.cn/article/jhojo.html