如何利用OBJECT_DEFINITION系统函数进行SQL Server 2005代码存档

DECLARE @i INT

SET @i = 1



WHILE @i <= 20

BEGIN
      EXECUTE
      (
      'IF OBJECT_ID(''usp_TestProcedure'+@i + ''')>0
            DROP PROCEDURE usp_TestProcedure'+@i+'
      '
      )
      EXECUTE
      (
      '
      CREATE PROCEDURE usp_TestProcedure' + @i + '
      AS
      BEGIN
                       PRINT ''The name of this procedure is '' + CAST(OBJECT_NAME(@@PROCID) AS VARCHAR(20)) 
      END'
      )
      SET @i = @i + 1

END