| How to
obtain the definition of all the functions? |
|
Execute the following
script in Query Editor to obtain the definition of scalar-valued,
in-line and table-valued functions:
USE AdventureWorks;
SELECT Type, Definition
FROM sys.sql_modules m
JOIN sys.objects o
ON m.object_id = o.object_id
AND TYPE IN ('FN', 'IF', 'TF')
ORDER BY Type, Definition;
|
| American Standard
in SQL Server 2005 Training |
|