Pages

Wednesday, September 11, 2013

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database | Journey to SQL Authority with Pinal Dave

SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT s.name FROM sysobjects s WHERE type =… Continue Reading...

Source: SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database | Journey to SQL Authority with Pinal Dave