存储过程以拆分字符串并将Pass作为参数 [英] Store Procedure to split a string and Pass as arguments

问题描述

我是sql的新手.

我想创建一个过程，该过程将传入的字符串按空格进行拆分，并在每个单词之间应用"AND"，并从表中检索(％"之类的％")行.

谁能帮我.

谢谢

Hi,

I am new to sql.

I want to create a procedure that splits the incoming string with respect to space and apply ''AND'' between each of the word and retrive the (''%''like''%'') rows from a table.

Can anyone help me.

Thanks

推荐答案

请检查该线程@

Please check this thread @ how to extract comma seperated values in sp using SQL server 2000[^]

这篇关于存储过程以拆分字符串并将Pass作为参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！