Interviews - C# Corner

Satyaprakash Samantaray
How display code or Text of Stored Procedure using Sql query in Sql Server ?
By Satyaprakash Samantaray in SQL Server onFeb 12 2017
  • Satyaprakash Samantaray
    Feb, 2017 12

    sp_helptext 'Name Of Stored_Procedure'e.g. sp_helptext SP_EmailDeatails

    • 5
  • Nihar Narendra
    Apr, 2017 18

    sp_helptext StoredProcedure Name Ex:sp_helptext GetClientdetails

    • 3
  • sushil kumar
    Apr, 2017 9

    sp_helptext sroredprocedurename ex: sp_helptext sp_GetDetails

    • 3
  • Ani
    Jul, 2017 28

    sp_helptext Ex:sp_helptext GetEmployeeDetails

    • 1
  • Rajkiran Swain
    May, 2017 15

    sp_helptext

    • 1
  • Bidya Mishra
    Apr, 2017 19

    sp_helptext

    • 1
  • Ravi Patel
    Jul, 2019 26

    Sp_helpText ‘SP name’

    • 0
  • Manish Maharjan
    Jan, 2019 19

    Sp_helptext 'Sp_name'

    • 0
  • Ravi Patel
    Nov, 2018 3

    sp_helptext 'StoredProcedure Name'

    • 0
  • Suresh Kumar
    Oct, 2017 28

    sp_helptext "your stored procedure name"eg:sp_helptext usp_getstudentdetails

    • 0
  • Shailendra Kumar
    Oct, 2017 24

    sp_helptext NameofProcedure

    • 0
  • Mukesh Kumar
    Sep, 2017 2

    By using system stored procedureSp_helptext

    • 0
  • Ritesh Singh
    Aug, 2017 22

    sp_helptext

    • 0
  • Pinakee Das
    Aug, 2017 21

    The following query can also be used: SELECT r.ROUTINE_DEFINITION from information_schema.routines r where r.ROUTINE_NAME='uspGetEmployeeManagers' and r.ROUTINE_TYPE='PROCEDURE' Here 'uspGetEmployeeManagers' is the name of the procedure

    • 0
  • Navneet Arora
    Apr, 2017 24

    EXEC [ServerName].[DatabaseName].dbo.sp_HelpText 'storedProcName'

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS