SQL Quick, viewing a store procedure

I had to blog this, seems as though it took me almost an hour to find ;)

If you want to view a stored procedure using SQL, how do you do it?

The command I found to work is:

EXEC sp_HelpText "yourStoredProcName"

Then to alter it, you do as follows


USE AdventureWorks2012;
GO
ALTER PROCEDURE Purchasing.uspVendorAllInfo
    @Product varchar(25) 
AS
  codeOfProc....
GO

Comments

Popular Posts