sybase在所有用户表中创建指定列（不定）的索引(没有不创建)OK_待完美

create procedure createIndexForBill
(@columnNames varchar(256))
as
begin
DECLARE @CID int
DECLARE @tmpTableName varchar(64)
DECLARE @tmpColumnName varchar(64)
DECLARE @INDEXNAME varchar(256)
DECLARE @sql varchar(512)
DECLARE @POS  int
DECLARE @HAVE varchar(32)
DECLARE CUR_INFO CURSOR FOR select a.colid as id,b.name as tab_name,a.name as col_name from syscolumns a,sysobjects b,systypes c  where a.id=b.id and a.usertype=c.usertype and b.type= 'U' order by a.colid
OPEN CUR_INFO
FETCH next from CUR_INFO INTO @CID,@tmpTableName,@tmpColumnName
WHILE @@SQLSTATUS = 0
    BEGIN
        SET @POS = charindex(@tmpColumnName,@columnNames)
        IF @POS > 0
        BEGIN
            /*
                        IF EXISTS(SELECT 1 FROM sysindexes WHERE name = @INDEXNAME)
                        BEGIN
                           SET @sql = 'drop index' +@INDEXNAME
                           EXEC @sql
                        END
            */
            SET @INDEXNAME = @tmpTableName+'_'+@tmpColumnName+'_'+convert(varchar,@CID)
            SET @sql = ' create nonclustered index '+ @INDEXNAME + ' on  '+@tmpTableName+'('+@tmpColumnName+')'
            EXEC (@sql)
            SELECT @sql
            --SELECT  @CID,@tmpTableName,@tmpColumnName
        END
        
        FETCH next from CUR_INFO INTO @CID,@tmpTableName,@tmpColumnName
    End
CLOSE CUR_INFO
DEALLOCATE CUR_INFO
END