sqlserver截取Email中@前后的用户名和域名

select SUBSTRING(Email,1,CHARINDEX('@',Email)-1)from StudentInfo
select SUBSTRING(Email,CHARINDEX('@',email)+1,LEN(Email)-CHARINDEX('@',Email)) from StudentInfo