清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

SELECT substring(columnname,0,CHARINDEX('/',a)) as firststr,substring(columnname,CHARINDEX('/',columnname)+1,len(columnname)-CHARINDEX('/',columnname)) as secondstr
  FROM talbename