select convert(varchar(10), dateadd(day, number - 1, '2015-01-01'), 120) as taskDate
from master.dbo.spt_values WHERE type='P' AND number <= datediff(day, '2010-01-01', '2020-02-01') + 1
AND number>0
select convert(varchar(10), dateadd(day, number - 1, '2015-01-01'), 120) as taskDate
from master.dbo.spt_values WHERE type='P' AND number <= datediff(day, '2010-01-01', '2020-02-01') + 1
AND number>0
需求:某一列单元格内容为逗号分隔的整数序列,形如(11,22);解析并
写SQL还是写代码
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M