--CREATE NONCLUSTERED INDEX qqNum on QQNumber100(QQNumber) declare @i int DECLARE @sql_str VARCHAR(MAX) set @i=102 while @i<1000 begin set @sql_str = ‘CREATE NONCLUSTERED INDEX qqNum on QQNumber‘+CAST(@i AS VARCHAR(10))+‘(QQNumber)‘ PRINT @sql_str EXEC (@sql_str) set @i=@i+1 end
原文：http://www.cnblogs.com/tina-smile/p/4746521.html
