時機律動來往間

ALTER PROCEDURE usp_HelpIndex
AS
DECLARE @tabName varchar(50), @statements varchar(100);
BEGIN
    SET NOCOUNT ON;
DECLARE cur CURSOR FOR
    SELECT name FROM sysobjects WHERE xtype='u' ORDER BY 1
    
    OPEN cur
    FETCH NEXT FROM cur INTO @tabName
    

    WHILE (@@FETCH_STATUS = 0)
    BEGIN
        SET @statements = 'EXEC sp_HelpIndex ' + @tabName

        INSERT INTO ut_HelpIdx
        EXECUTE(@statements)

        FETCH NEXT FROM cur INTO @tabName
    END
CLOSE cur
DEALLOCATE cur

END

/**** table ut_HelpIdx ****/
CREATE TABLE [dbo].[ut_HelpIdx](
    [idxName] [varchar](50) NULL,
    [idxDesc] [varchar](200) NULL,
    [idxKeys] [varchar](200) NULL
) ON [PRIMARY]