此存储过程可以自动将指定表的全部字段自动建立索引
create proc createallindex
@table varchar(200)
as
begin
declare cur_webpages cursor
for select name from syscolumns where id =(select id from sysobjects where name=@table)
declare @name sysname
declare @indexname varchar(300)
declare @i int
set @i=0
open cur_webpages
fetch next from cur_webpages into @name
while (@@fetch_status=0)
begin
set @i=@i+1
set @indexname=@table+convert(char,@i)
exec ('create index '+@indexname+' on '+ @table+'('+@name+')')
fetch next from cur_webpages into @name
end
close cur_webpages
deallocate cur_webpages
end
GO
用法:
exec createallindex 'Employee'