declare @str varchar(50)
set @str = reverse(substring(reverse('192.168.1.100'),1,charindex('.',reverse('192.168.1.100')) - 1))
select @str
转载于:https://www.cnblogs.com/demo8/p/3682265.html
declare @str varchar(50)
set @str = reverse(substring(reverse('192.168.1.100'),1,charindex('.',reverse('192.168.1.100')) - 1))
select @str
转载于:https://www.cnblogs.com/demo8/p/3682265.html