DECLARE @site VARCHAR(10)
SET @site='test_123'
Select Substring(@site,0,CHARINDEX('_',@site))
Select Substring(@site,CHARINDEX('_',@site)+1,Len(@site))
转载于:https://www.cnblogs.com/andy_tigger/archive/2010/07/26/1785494.html
转载于:https://www.cnblogs.com/andy_tigger/archive/2010/07/26/1785494.html