declare @s varchar(4000) set @s='2115,2116,2117' select * from TestInfo where charindex(','+adress+',',','+@s+',')>0
create FUNCTION fn_Information( --========================================================== --Author: alice --Create Time: 2015/03/04 --Description: 创建函数,用于传入字符串,将字符串以逗号分开,放入返回表中 --Version : 1.0 --========================================================== @arr AS VARCHAR(max) --传入参数 ) RETURNS @t TABLE( --返回表 pos INT NOT NULL, --单号 nvalue VARCHAR(5000) NOT NULL --拆分结果 ) AS BEGIN DECLARE @end AS INT, --开始 @start AS INT, --结束 @pos AS INT --排号 SELECT @arr = @arr + ',', --逗号赋值 @pos = 1, @start = 1, @end = CHARINDEX(',', @arr, @start) WHILE @end > 1 BEGIN INSERT INTO @t VALUES(@pos, SUBSTRING(@arr, @start, @end-@start)) SELECT @pos = @pos + 1, @start = @end + 1, @end = CHARINDEX(',', @arr,@start) END RETURN END SELECT * FROM tableName WHERE ADDRESS in(SELECT * FROM dbo.fn_Information('2115,2116,2117'))
34,590
社区成员
254,589
社区内容
加载中
试试用AI创作助手写篇文章吧