Stored Procedure to display code (text) of SP, Trigger, View

Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object

This is another popular question is How to see text/content/code of Stored Procedure. System stored procedure that prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, or view?


exec sp_helptext      rpt_sprocLandlord

Return is

CREATE proc [dbo].[rpt_sprocLandlord] 
@wcode varchar(35) ='ac-nasik%' 
as 
SELECT     Vendor.VendorName, Vendor.Address, Cities.City,  
                      Vendor.PinCode, Vendor.ContactPerson, Vendor.ContactNo,  
                      Vendor.MobileNo, Vendor.FaxNo, Vendor.EmailID,  
                      WarehouseVendor.DOA, WarehouseVendor.ASF, WarehouseVendor.AET,  
                      WarehouseVendor.Area, WarehouseVendor.RatePerSqft, WarehouseVendor.Rent,  
                      WarehouseVendor.DepositMonth, WarehouseVendor.DepositAmt,  
                      WarehouseVendor.ChequeNo, WarehouseVendor.ChequeDate,Warehouse.WID 
FROM         WarehouseVendor INNER JOIN 
                      Warehouse ON WarehouseVendor.WID = Warehouse.WID INNER JOIN 
                      Vendor ON WarehouseVendor.VendorID = Vendor.VendorID INNER JOIN 
                      Cities ON Vendor.CityID = Cities.CityID 
where Vendor.VendorType = 0 and Warehouse.WCODE like @WCODE 
and WarehouseVendor.Activate = 1