如何使用sql查询拆分多个参数 [英] how to split the multiple paramerters using sql query
本文介绍了如何使用sql查询拆分多个参数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,如何在sql server中使用','分割大文本
我的查询是这样的,
选择 SUBSTRING(' city, sate,county,vvv', 0 ,CHARINDEX(' ,',' city,sate', 0 ))
选择 SUBSTRING(' city,sate,county,vvv',
(CHARINDEX(' ,',' city,sate,county,vvv', 0 )+ 1),(lEN(' 城市,国家,县,vvv') - (CHARINDEX(' ,',' city,sate,county,vvv', 0 ))))
选择 SUBSTRING(' city,sate,county,vvv',
( CHARINDEX(' ,',' < span class =code-string> city,sate,county,vvv', 0 )+ CHARINDEX(' ,',' city, sate,county,vvv', 0 )),(lEN(' city,sate,county,vvv') - (CHARINDEX(' , ',' city,sate,county,vvv' , 0 ))))
给予2个参数即城市,国家工作正常。但是有2个或更多参数不能正常工作。
i想要输出这种格式。
city ='city',
州='州',
县='县',
vvv ='vvv'
即用逗号分隔或拆分这个词。如何写查询。
请帮助我,
解决方案
看看 SQL Server - 将CSV拆分为单独的行值 [ ^ ]
使用此功能可以帮助你
http://www.aspdotnet-suresh.com/2013/07/sql-server-split-function-example-in.html [ ^ ]
Hi all how to split the large text by using ',' in sql server
my query like this,
select SUBSTRING('city,sate,county,vvv',0,CHARINDEX(',','city,sate',0))
select SUBSTRING('city,sate,county,vvv',
(CHARINDEX(',','city,sate,county,vvv',0)+1),(lEN('city,sate,county,vvv')-(CHARINDEX(',','city,sate,county,vvv',0))))
select SUBSTRING('city,sate,county,vvv',
(CHARINDEX(',','city,sate,county,vvv',0)+CHARINDEX(',','city,sate,county,vvv',0)),(lEN('city,sate,county,vvv')-(CHARINDEX(',','city,sate,county,vvv',0))))
am given to 2 parameters i.e city, state working fine. but 2 or more parameters are am given not working exactly.
i want output this format .
city='city',
state='state',
county='county',
vvv='vvv'
i.e separated or split by comma this words. how to write the query.
please help me,
解决方案
Take a look at SQL Server - Split CSV into separate row values[^]
use this function it may help you
http://www.aspdotnet-suresh.com/2013/07/sql-server-split-function-example-in.html[^]
这篇关于如何使用sql查询拆分多个参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文