O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Built-In User-Defined Functions

SQL Server 2000 implements some system functions as built-in user-defined functions. Many of them are not documented; Query Analyzer, Enterprise Manager, Profiler, Replication, and other client applications and system processes use some of these built-in user-defined functions internally. These functions can be used almost as any other user-defined function, but SQL Server itself implements them.

You cannot change the definition of these built-in user-defined functions. In some cases, you cannot see their definition using the sp_help or sp_helptext system stored procedures, and you cannot script them. However, their definition is stored in the syscomments system table as any other user-defined function.

Caution ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required