在sql server 2008中的存储过程中拆分 [英] Split in stored procedure in sql server 2008
本文介绍了在sql server 2008中的存储过程中拆分的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
i正在处理sql server中的存储过程,
我在哪里一个带有datatyep nvarchar(max)的变量,
ni想要拆分它,变量已经有','逗号。
我的代码:
alter proc sp_GetSeletedTrucks
@tid nvarchar(max)
as
从TruckTracking中选择*,其中DoorNo in(@tid)
其中@tid ='101,102,103'< br $>
plzzzz ...建议我。
谢谢
解决方案
见这里:在SQL IN子句中使用逗号分隔值参数字符串 [ ^ ]
Google根据您的要求,搜索可以给您很多结果。
One , Two
查看类似的问题和答案:如何从SQL中的字符串中获取字符? [ ^
Hi guys,
i was working on stored procedures in sql server,
where i have a variable with datatyep nvarchar(max),.
n i want to split it, the variable is already having ',' commas.
my code:
alter proc sp_GetSeletedTrucks @tid nvarchar(max) as select * from TruckTracking where DoorNo in (@tid)
where @tid = '101,102,103'
plzzzz... suggest me.
thanks
解决方案
See here: Using comma separated value parameter strings in SQL IN clauses[^]
A Google search can give you many results depending on your requirement.
One, Two
Have a look at similar question and answers: how to get the character from string in SQL ?[^]
这篇关于在sql server 2008中的存储过程中拆分的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文