摘要:
DECLARE @StartTime AS DATETIME SET @StartTime= '2016-5-10 ' DECLARE @t TABLE(dDate DATETIME) --计算连续时间 WHILE @StartTime <= '2016-5-13 ' BEGIN INSERT IN 阅读全文
摘要:
找到全部子集 WITH TEMP AS ( SELECT * FROM CM_Region WHERE RegionCode='110000' UNION ALL SELECT T0.* FROM TEMP,CM_Region T0 WHERE TEMP.RegionCode=T0.ParentCo 阅读全文