Collections:
sys.sql_modules - Getting User Defined Function Definitions Back in SQL Server
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want get the definition of an existing user defined function back from the SQL Server, you can use the system view called sys.sql_modules, which stores definitions of functions, stored procedures, and views.
The sys.sql_modules holds user defined function definitions identifiable by the object id of each function. The tutorial exercise below shows you how to retrieve the definition of stored procedure, "Sundays" by joining sys.sql_modules and sys.objects:
USE FyiCenterData; GO SELECT m.definition FROM sys.sql_modules m, sys.objects o WHERE m.object_id = o.object_id AND o.name = 'Sundays'; GO definition ----------------------------------------------- CREATE FUNCTION Sundays() RETURNS INT AS BEGIN DECLARE @date DATETIME; DECLARE @count INT; SET @date = '2006-12-31'; SET @count = 0; WHILE DATEPART(YEAR, @date) <= 2008 BEGIN SET @date = DATEADD(DAY, 1, (1 row(s) affected)
2016-12-18, 1268👍, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...