declare @src_sql varchar(10)
set @src_sql = 'cccyyyy%_mm%aaa'
set @src_sql = replace(replace(@src_sql,'mm%','07'),'yyyy%','2007')
print @src_sql结果是
ccc2007_m
set @src_sql = 'cccyyyy%_mm%aaa'
set @src_sql = replace(replace(@src_sql,'mm%','07'),'yyyy%','2007')
print @src_sql结果是
ccc2007_m
set @src_sql = 'cccyyyy%_mm%aaa'
set @src_sql = replace(replace(@src_sql,'mm%','07'),'yyyy%','2007')
print @src_sql
--------
ccc2007_07aaa
同意楼上.declare @src_sql varchar(20)
set @src_sql = 'cccyyyy%_mm%aaa'
set @src_sql = replace(replace(@src_sql,'mm%','07'),'yyyy%','2007')
print @src_sql
--------
ccc2007_07aaa