sqlserver以‘/’拆分数据
- 作者: 隔壁老王我最长
- 来源: 51数据库
- 2022-08-17
SELECT substring(columnname,0,CHARINDEX('/',a)) as firststr,substring(columnname,CHARINDEX('/',columnname)+1,len(columnname)-CHARINDEX('/',columnname)) as secondstr
FROM talbename
推荐阅读
