Search results
You will learn about SQL Server user-defined functions including scalar-valued functions and table-valued functions to simplify your development.
Summary: in this tutorial, you will learn how to use SQL Server table-valued function including inline table-valued function and multi-statement valued functions. What is a table-valued function in SQL Server. A table-valued function is a user-defined function that returns data of a table type. The return type of a table-valued function is a ...
Using table variables in user-defined functions. The following user-defined function named ufnSplit() that returns a table variable.
Home » SQL Server User-defined Functions » SQL Server Scalar Functions SQL Server Scalar Functions Summary : in this tutorial, you will learn about SQL Server scalar functions and how to use them to encapsulate formulas or business logic and reuse them in the queries.
This tutorial shows you how to use the SQL Server DROP FUNCTION to remove one or more existing user-defined functions.
In SQL Server, a table-valued function is a user-defined function that returns multiple rows as a table. The CROSS APPLY clause works like an INNER JOIN clause. But instead of joining two tables, the CROSS APPLY clause joins a table with a table-valued function or a correlated subquery.
SQL Server triggers are special stored procedures that are executed automatically in response to the database object, database, and server events. SQL Server provides three type of triggers: Data manipulation language (DML) triggers which are invoked automatically in response to INSERT, UPDATE, and DELETE events against tables.
In SQL Server, a table-valued function is a user-defined function that returns multiple rows as a table. The OUTER APPLY clause works like a LEFT JOIN clause. However, instead of joining two tables, the OUTER APPLY clause joins a table with a table-valued function or a correlated subquery.
In this section, you will learn about SQL Server user-defined functions including scalar-valued functions and table-valued functions to simplify your development.
Summary: in this tutorial, you will learn SQL Server IF...ELSE statement to control the flow of program. The IF...ELSE statement is a control-flow statement that allows you to execute or skip a statement block based on a specified condition.
