CREATE FUNCTION [dbo].[FDT_DELETE_ZK_SPACE](
@str nvarchar(4000)
) returns nvarchar(4000)
as
begin
declare @endp int,@endflag int,@length int,@i int,@j int, @appstr nvarchar(4000)
,@reversestr nvarchar(4000),@return_str nvarchar(4000)
select @endflag = 0,@length=len(@str),@i=1,@reversestr = reverse(@str),@endp = 0
if(SUBSTRING(@reversestr,1,1) = ‘ ‘)
begin
return @str
end
while (@endflag = 0 and @i<=@length)
begin
if(SUBSTRING(@reversestr,@i,1) != ‘\u0081\u3000’)
begin
set @endflag = 1
set @endp = @length – @i + 1
end
set @i = @i + 1
end
set @return_str = substring(@str,1,@endp)
set @j=1
set @appstr= ”
while(@j<=2*(@i-2))
begin
set @appstr = @appstr + ‘ ‘
set @j = @j + 1
end
set @return_str = @return_str + @appstr
return @return_str
end <\/p>\n","protected":false},"excerpt":{"rendered":"
CREATE FUNCTION [dbo].[FDT_DELETE_ZK_SPACE]( @str nvarc … \u7ee7\u7eed\u9605\u8bfb sqlserver\u53bb\u6389\u5b57\u7b26\u4e32\u7ed3\u5c3e\u7684\u5168\u89d2\u7a7a\u683c\u5e76\u7528\u534a\u89d2\u66ff\u6362<\/span>