declare @s nvarchar(50)
set @s='我一口就把水给喝了/厉害';
select substring(@s,charindex('/',@s)+1,len(@s)-charindex('/',@s))

------解决方案--------------------
string result=str.Split('/')[1];

------解决方案--------------------
SQL code
DECLARE @str nvarchar(2000)
SET @str='我一口就把水给喝了/厉害'
SELECT RIGHT(@str,LEN(@str)-CHARINDEX('/',@str))

------解决方案--------------------
SQL code

declare @s1 as nvarchar(100)
declare @result as nvarchar(100)
set @s1 = 'ABCDEFGHIGK/LMASDFASDF';

print @s1

declare @pos as int
set @pos = CHARINDEX('/', @s1, 0)
set @result = RIGHT(@s1, LEN(@S1) - @pos)
print @result