Abstract
There are two types of functions available in SQL Server 2000: built-in and user-defined. Built-in functions are a part of T-SQL, and they are similar in nature to functions you have used in other programming languages. For example, Visual Basic uses the NOW function to return the current system time while T-SQL uses the GETDATE() function to return the same information. User-defined functions,which are new to SQL 2000, are functions you create using the CREATE FUNCTION statement. User-defined functions are covered in detail in Chapter 7.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2001 Garth Wells
About this chapter
Cite this chapter
Wells, G. (2001). Built-In Functions. In: Code Centric: T-SQL Programming with Stored Procedures and Triggers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-1145-7_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1145-7_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-893115-83-5
Online ISBN: 978-1-4302-1145-7
eBook Packages: Springer Book Archive