In this video, Joed Goh talks about Functions In SQL Server 2022. You will learn how to encapsulate a set of SQL statements to perform a specific task and reuse them throughout your queries. This lesson covers the discussion of built-in functions and user-defined functions. You'll explore some of the most commonly-used built-in functions in SQL Server like date and time functions, string functions, mathematical functions, and aggregate functions. You’ll learn how to create your own user-defined functions so that your database systems benefit from code reusability, flexibility, and performance.
Table of Contents:
00:00 Introduction
01:28 String Functions
03:28 Date and Time Functions
05:32 Mathematical Functions
06:08 Aggregate Functions
07:33 User-Defined Function
09:26 Scalar-Valued Function
13:22 Table-Valued Function
PLAYLISTS:
Designing Database Solutions with Microsoft SQL Server 2019
[ Ссылка ]_
Artificial Intelligence and Machine Learning Foundations
[ Ссылка ]
IoT Development
[ Ссылка ]
Android App Development in Kotlin
[ Ссылка ]
Embedded Systems using Arduino Uno
[ Ссылка ]
Data Structures and Algorithms using C#
[ Ссылка ]
