What is an SQL Window Function? A window is a set of rows or observations in a table or result set. In a table, you may have more than one window depending on how you specify the query.

With the latest release of SQL Server, Microsoft produced 14 new T-SQL functions. These functions can be separated into four different categories, as seen in Table 1. These functions will be ...

This article highlights the different commonly used SQL functions as exit in the analysis of data such as the aggregate functions, string functions, date functions and others. The arithmetic function ...

Splits the text according to each : character in the example:value:data variable. The result will be a table with 3 rows.

This project demonstrates the use of various SQL Server window functions in an existing database context. Window functions provide powerful capabilities for analyzing and reporting on data, such as ...

To encrypt and decrypt a string we have a predefined functions in Sql Server 2008 that are easy to use. Suppose we want to save some data that doesn't need to be exposed as a plain text then in such ...