/*求第一个字符串中第二个字符串的个数*/
create FUNCTION [dbo].[m_sqlcount]
(
@Str_One nvarchar(200),
@Str_Two nvarchar(200)
)
RETURNS int AS
BEGIN
DECLARE @sqlcount int
select @sqlcount=
( LEN( @Str_One ) - LEN( replace( @Str_One, @Str_Two,'' ) ) ) / LEN( @Str_Two)
RETURN @sqlcount
END