程序猿刚子的博客

摘要： DECLARE @items VARCHAR(max) DECLARE @temp_item VARCHAR(max)SET @items = '1,2,3,4,5,6'CREATE TABLE #temp_table(item INT)WHILE(len(@items) > 0)BEGIN IF (charindex(',', @items) = 0) BEGIN SET @temp_item = @items SET @items = '' END ELSE BEGIN SET @temp_item = LEFT... 阅读全文