SqlServer拆分列

SELECT TOP 1000 substring([a],0,CHARINDEX('/',a)) as low,substring([a],CHARINDEX('/',a)+1,len([a])-CHARINDEX('/',a)) as height
  FROM [JHEMR].[dbo].[a]

posted @ 2014-08-14 15:50  喜爱糖葫芦  阅读(162)  评论(0编辑  收藏  举报