34,576
社区成员
发帖
与我相关
我的任务
分享
create table #t_dir(t varchar(max))
Insert #t_dir
exec xp_cmdshell 'dir /a-d /-c /tw G:\Input\EAST_V1\output\'
delete #t_dir where t is null
delete #t_dir where len(t)!=len(rtrim(ltrim(t)))
select ltrim(rtrim(substring(ltrim(substring(t,18,5000)),1, CHARINDEX(' ',ltrim(substring(t,18,5000)))))),ltrim(rtrim(substring(ltrim(substring(t,18,5000)), CHARINDEX(' ',ltrim(substring(t,18,5000))),1000))) from #t_dir