Viewing and Modifying User-Defined Functions

Besides using T-SQL commands to create functions, you can also use them to view and modify functions. You can get information by using the provided system procedures and queries against system views. The following sections describe these methods.

Using T-SQL to View Functions

There are multiple methods to view the source code for a user-defined function. One way is to use the sp_helptext procedure:

Click here to view code image

use AdventureWorks2012goexec sp_helptext getonlydatego/* resultText--------------------------------------------------------------------CREATE FUNCTION getonlydate ()RETURNS datetimeASBEGIN   RETURN (select convert(datetime, convert(date, getdate())))END*/

Note

To display ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial