Mar 20, 2013 · You can use sp_helptext command to view the definition. It simply does. Displays the definition of a user-defined rule, default, unencrypted Transact-SQL stored procedure, user-defined Transact-SQL function, trigger, computed column, CHECK constraint, view, or system object such as a system stored procedure. E.g;

Aug 9, 2018 · -- using the two system tables sys.sql_modules and sys.objects . FROM sys.sql_modules AS sm . JOIN sys.objects AS o ON sm.object_id = o.object_id . -- from the function 'dbo.ufnGetProductDealerPrice' . WHERE sm.object_id = OBJECT_ID('dbo.ufnGetProductDealerPrice') . ORDER BY o.type; . GO . Find the answer to your question by asking.

Jan 28, 2015 · Below are three simple ways to use a SQL query to get the text of a stored procedure, trigger, function, etc. Method #1: SYS.SQL_MODULES. sys.sql_modules is a system DMV (Dynamic Management View) that returns a row for each object that is an SQL language-defined module in SQL Server.

For legibility, you can use the \x psql meta-command before displaying the function definition. \x is also useful for viewing query results containing records with long strings. \ef <function_name> in psql. It will give the whole function with editable text. Exact answer. This will open function definition in editor. This is the best answer!

Feb 9, 2012 · That's most likely code deep inside the SQL Server core. As a proof - you can e.g. get the body of other system stored functions using sp_helptext : sp_helptext 'sys.fn_isrolemember'

Jan 28, 2025 · Find text in stored procedures, functions, views, triggers by searching SQL Server system tables using PowerShell and SQL.

May 25, 2007 · 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. Syntax

May 23, 2023 · All built-in string functions except FORMAT are deterministic. This means they return the same value any time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

SQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server. SQL Server String Functions

Jul 29, 2020 · In this tutorial, we’ll discuss on how to find Stored Procedures, Views and Functions which contain a particular text in it. Also, we’ll discuss on how to find tables which has a column name with a particular text.