摘要： declare @str as nvarchar(50)set @str = N'.0.1.1001.2002.3.204.5.106.'declare @str_tmp as nvarchar(30)declare @index as intdeclare @str_len as intselect @str_len=LEN(@str)select @index=CHARINDEX('.',@str, 1)if @index = 1set @str = RIGHT(@str, len(@str) - 1)if RIGHT(@str, 1) = '.&# 阅读全文