22,300
社区成员




declare @str as varchar(100)
set @str = '1231232312312313123'
select '12的个数'=(len(@str) - len(replace(@str,'12','')))/2 ,
'23的个数'=(len(@str) - len(replace(@str,'23','')))/2 ,
'31的个数'=(len(@str) - len(replace(@str,'31','')))/2 ,
'总数' = (len(@str) - len(replace(@str,'12','')))/2 +
(len(@str) - len(replace(@str,'23','')))/2 +
(len(@str) - len(replace(@str,'31','')))/2
/*
12的个数 23的个数 31的个数 总数
----------- ----------- ----------- -----------
5 6 5 16
(所影响的行数为 1 行)
*/
declare @str as varchar(100)
set @str = '1231232312312313123'
select (len(@str)-len(replace(@str,'1231','')))/4