循环建立索引

--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

View Code

 

转载于:https://www.cnblogs.com/tina-smile/p/4746521.html