对于结果集包含NULL的情况: 1,当用IN时,若在结果集中存在,则返回TRUE,若在结果集中不存在,因结果集中有NULL,则返回UNKNOWN, UNKNOW...
总则:观察规律,将规律固定下来。 连续范围:1,2,3,4,7,8,11,12,15 连续范围为:1,2,3,4 | 7,8 |11,12 特点:若按从小到大的...
可执行任意进制转换,2进制,8进制,32进制,36进制,进制数依赖于所能表示的字典数,如下'0123456789ABCDEFGHIJKLMNOPQRSTUVWX...
中值:若总数为奇数,则中数为中间那个,若为偶数,则为中间两个平均 WITH RN AS(SELECT CONVERT(VARCHAR(10),a.OrderDa...
SELECT a.salesstaff,a.OrderNo,a.OrderDate,a.Amount, SUM(amount) OVER (PARTITION ...
WITH tmpArray AS ( SELECT 'A' NAME , '20,233,2544,25567,14' array UNION ALL SELE...
SELECT CAST(CAST (100.* 1/CASE(2) WHEN 0 THEN 1 ELSE 2 END AS DECIMAL(5,2)) AS V...
将ParentID结构形式的表转换成以OrganID为形式的表 ?现有一地区表mdCity,结构为: ID? ParentID Name 1??? 0??? 安...
WITH orderdata AS( SELECT bo.OrderNo,bo.OrderDate,bo.Amount, NTILE(10) OVER (ORD...
查询表空间及行数 SELECT OBJECT_NAME(id) AS TableName , rowcnt AS ROWS, reserved * 8.0 AS...