Monday, August 2, 2010

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database

DECLARE @procName VARCHAR(100)

DECLARE @getprocName CURSOR

SET @getprocName = CURSOR FOR

SELECT s.name

FROM sysobjects s

WHERE type = 'P'

OPEN @getprocName

FETCH NEXT

FROM @getprocName INTO @procName

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC sp_HelpText @procName

FETCH NEXT

FROM @getprocName INTO @procName

END

CLOSE @getprocName

DEALLOCATE @getprocName

GO

 

Source : http://blog.sqlauthority.com

No comments:

Post a Comment