update table1 set text1=replace(text1,'list/任意位数的字符/','list/任意位数的字符/你好啊') update t set text1=reverse(stuff(reverse(text1) ,charindex('.',reverse(text1)) ,0 ,reverse('list/任意位数的字符/你好啊') ) )