Sql
query to get script or text of any stored procedures in sql server
We can get the script or text of
stored procedure without modifying the procedure by using the system stored procedure
sp_helptext. Synatx:
EXECUTE sp_helptext
<ProcedureName>
For example:
EXECUTE sp_helptext 'usp_getdata'
Other sql script:
SELECT m.definition
FROM sys.sql_modules m INNER
JOIN Sys.procedures p
ON m.object_id = p.object_id AND p.name = 'AppProc'
No comments:
Post a Comment