SQL中判断一串字符中是否有特定的字符
摘要:
DECLARE @s VARCHAR(100),@sql VARCHAR(1000)SET @s='1,2,3,4,5,6,7,8,9,10'一:SET @sql='select col='''+ replace(@s,',',''' union all select ''')+''''PRINT ... 阅读全文
posted @ 2015-04-23 15:54 Harry Han 阅读(1526) 评论(0) 推荐(0) 编辑