- SELECT substring(columnname,0,CHARINDEX('/',a)) as firststr,substring(columnname,CHARINDEX('/',columnname)+1,len(columnname)-CHARINDEX('/',columnname)) as secondstr
- FROM talbename
- --该片段来自于http://www.codesnippet.cn/detail/1509201410373.html
来源: http://www.codesnippet.cn/detail/1509201410373.html