循环建立索引 

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

 

posted @ 2015-08-20 23:15  smile_tina  阅读(310)  评论(0)  编辑  收藏  举报