New Advances in SQL Server Functions
All programming languages, including T-SQL, have functions that can be used to create powerful applications. In most languages, programmers can create their own functions that allow them to expand on what the system can do. In previous versions of SQL Server, you didn't have the ability to create functions. You could create stored procedures but couldn't use them in certain places, such as within the context of a SELECT statement. Now, SQL Server 2000 now enables you to create your own functions.
A function is simply a subroutine that encapsulates SQL statements. By creating functions, you can easily reuse the code that you have created to compare and contrast the differences between functions and stored ...
Get Writing Stored Procedures for Microsoft SQL Server 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.
