摘要： declare @idx int, @str nvarchar(1000)set @str = '我的字符串'set @idx = 1while @idx <= len(@str)begin PRINT substring(@str, @idx, 1)-- 取得@idx所在的这个字符 set @idx = @idx + 1end-----------------------------------------------------------------------结果：我的字符串 阅读全文

摘要： --在存储过程中where条件in（）的替代做法DECLARE @test NVARCHAR(50)SET @test='48,49,50,51';SELECT * FROM dbo.TbExamRecord WHERE CHARINDEX(','+CAST(reid AS NVARCHAR(10))+',',','+@test+',')>0--等同于SELECT * FROM dbo.TbExamRecord WHERE REID IN(48,49,50,51) 阅读全文