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
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