haitao · 2007-06-23 09:19:57 · 阅读: 411 先declare @tb varchar(100),@sql varchar(8000) select top 1 @tb=name from master.dbo.sysdatabases order by crdate desc set @sql='CREATE INDEX [IX_表1_字段1] ON '+@tb+' ([字段1])' exesql @sql