sdhdy的专栏

DECLARE @str varchar(8000),@search_str varchar(10)SELECT @str = abcefbpqbbpef,@search_str = bpSELECT CASE WHEN CHARINDEX(@search_str, @str) = 0 THEN 0ELSE LEN(@str) - CHARINDEX(REVERSE(@sear

create function GetNum(@a varchar(50))returns varchar(50)asbeginwhile patindex(%[^1-9]%,@a)>0begin    set @a=stuff(@a,patindex(%[^1-9]%,@a),1,)endreturn @aendgoselect dbo.GetNum(2a p9 asdf1234k

create function f_splitstr(@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(F1 varchar(100))as begin declare @i int set @SourceSql=rtrim(ltrim(@SourceSql)) set @i=charindex(@StrSep

比如一串数字14,23,64,23,14,20,30 其中14重复两次,23重复两次,其余没有重复。=================================declare @sql varchar(1000)declare @str varchar(100)set @str=14,23,64,23,14,20,30select @sql=select col,count

--把IP地址：127.0.0.1补全。select right(000+ParseName(LogIp,4),3)+.       +right(000+ParseName(LogIp,3),3)+.       +right(000+ParseName(LogIp,2),3)+.       +right(000+ParseName(LogIp,1),3) fr

create function GetStr(@a varchar(50))returns varchar(50)asbeginwhile patindex(%[^a-z]%,@a)>0begin    set @a=stuff(@a,patindex(%[^a-z]%,@a),1,)endreturn @aendgoselect dbo.getstr(2a p9 asdf1234k

create function StrLink(@id int)returns varchar(8000)asbegin declare @sql varchar(8000)     set @sql= select @sql=@sql+,+colname from tablename where id=@id set @sql=stuff(@sql,1,1,) return @sql

有一字段值为:a,b,c ，想要得到如下：id  name 1  a 2  b 3  c 在SQL中如何实现呢?-----------------------------------------------declare @str varchar(8000) set @str = a1,b1,c2,d1,e3,f5 set @str = select  name=+re

设有一字符串 111-222-333-444-555-666-777-888 用一SQL语句将其变为8个字段 ======================================declare @str varchar(100)set @str = 111-222-333-444-555-666-777-888set @str =  select +