12 2018 档案
摘要：Compares a scalar value with a single-column set of values. SOME and ANY are equivalent. Here is the example: it will return "TRUE", because 3 less th
阅读全文
摘要：The following explanation from MSDN LEAD provides access to a row at a given physical offset that follows the current row. Use this analytic function
阅读全文
摘要：As the name suggests: table-valued returns table, however Scalar-valued returns a single value, such as a string, integer, or bit value. 1、table-value
阅读全文
摘要：You also can read the Chinese version: 秋天的林子 SQLSERVER的阻塞和死锁 Sys.SysProcesses: it's a important system view, it can locate and resolve block and deadl
阅读全文
摘要：Sys.SysProcesses 系统表是一个很重要的系统视图，主要用来定位与解决Sql Server的阻塞和死锁 视图中主要的字段： 1. Spid：Sql Servr 会话ID 2. Kpid：Windows 线程ID 3. Blocked：正在阻塞求情的会话 ID。如果此列为 Null，则标识
阅读全文
摘要：ENCRYPTBYASYMKEY() --非对称密钥 ENCRYPTBYCERT() --证书加密 ENCRYPTBYKEY() --对称密钥 ENCRYPTBYPASSPHRASE() --通行短语（PassPhrase）加密 --非对称密钥包含数据库级的内部公钥和私钥，它可以用来加密和解密SQL
阅读全文
摘要：Some people prefer count(1) over count(*) and using count(1) to optimize his statements, but actually they have not difference. Here is test code and
阅读全文
摘要：下面是译文，你也可以看老外的文章：Stairway to SQL Server Security。 你需要保护你的server和数据，抵御当今复杂多变的攻击，在这些方面SQL Server都可以做到。但是在你使用这些安全有效的功能之前，你需要知道你面临的威胁和一些基本的安全概念。这篇文章是一些基础内
阅读全文
