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://cdkjz.cn/article/jhojo.html
