haitao: 先declare @tb varchar(100),@sql varchar(8000) [阅读: 392] 2007-06-23 09:19:57 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