摘要： declare @str nvarchar(100),@count int,@num1 int,@num2 intselect @str='1,2,3,4-6,7,8-15,24-30'select @str=','+@str+','while len(@str)-len(replace(@str,'-',''))>0beginselect @count=charindex('-',@str)pr... 阅读全文