--示例
create table #t(re varchar(8000))
insert #t exec master..xp_cmdshell 'set'select 类型=left(re,charindex('=',re)-1),值=stuff(re,1,charindex('=',re),'')
from #t
where re like 'ProgramFiles=%'
or re like 'SystemDrive=%'
or re like 'TEMP=%'
or re like 'windir=%'drop table #t/*--结果:类型 值
------------------- --------------------
ProgramFiles C:\Program Files
SystemDrive C:
TEMP C:\WINNT\TEMP
windir C:\WINNT(所影响的行数为 4 行)
--*/
create table #t(re varchar(8000))
insert #t exec master..xp_cmdshell 'set'select 类型=left(re,charindex('=',re)-1),值=stuff(re,1,charindex('=',re),'')
from #t
where re like 'ProgramFiles=%'
or re like 'SystemDrive=%'
or re like 'TEMP=%'
or re like 'windir=%'drop table #t/*--结果:类型 值
------------------- --------------------
ProgramFiles C:\Program Files
SystemDrive C:
TEMP C:\WINNT\TEMP
windir C:\WINNT(所影响的行数为 4 行)
--*/
嘿嘿,搞定,没想到command命令这么有用!!! 向 zjcxc(邹建) 老大致敬! 结帖!