SQL Server 求结果
2024-10-19 04:30:44
;with cte as (
select CONVERT(DATE, DATEADD(DAY, -9, GETDATE())) as paytime
union all
select dateadd(day,1,paytime) from cte where paytime<GETDATE()
)
select * from cte a
-----------猜猜结果是什么,下面的
paytime
2015-10-31
2015-11-01
2015-11-02
2015-11-03
2015-11-04
2015-11-05
2015-11-06
2015-11-07
2015-11-08
2015-11-09
2015-11-10
最新文章
- (转)AppiumLibrary基本操作
- zendstudio文件编码修改问题
- use IFS in bash
- [转]ORACLE的ProC用法讲解
- win8 telnet VirtualBox中的redhat9
- Java Concurrency - ReadWriteLock &; ReentrantReadWriteLock
- INSTALLING QUARTUS II V.13.1 64 BIT ON RHEL/CENTOS 6 64 BIT
- 用python爬取app照片
- 博弈论中的Nim博弈
- Init wms goodlocation data
- English trip V1 - 19.Where Am I? 我在哪里?Teacher:Patrick Key:Ask for and directions
- tomcat8 tomcat-users相关配置
- 【mysql】之性能优化
- Linux 网络命令找不到
- ios-复制字符串到剪贴板
- JavaBase
- Nodejs搭建wss服务器
- 一个JAVA的WEB服务器事例
- 002-ubuntu安装
- 问题:SpringBoot访问不到Controller