Tag: tsql

Editorials

Analytic Functions

Since SQL Server 2012 was released, the SQL Server engine supports a new class of aggregate functions they have named Analytic. You can find documentation for the Analytic.functions at https://docs.microsoft.com/en-us/sql/t-sql/functions/analytic-functions-transact-sql. What I find that is cool about these Analytic functions is that they extend beyond the existing set of aggregate functions, allowing you to build queries that you could do previously,…...

This content is for Free members only.
Log In Register
SQL Server

User-defined functions (UDFs) – Part-2

User-defined functions (UDFs) – Part-2 Author: Basit A. Farooq Editor’s Note: In this second of the two part article series, you’ll about creating and using in-line table functions, and multi-statement table functions. You used CREATE FUNCTION, ALTER FUNCTION, DROP FUNCTION, and SQL Server Management Studio to create and manage functions. You learned about a related object, CLR aggregates. Creating a […]

Pro Members SQL Server Standard Members

Back to basics: Transact-SQL programming fundamentals – (Part 1)

Back to basics: Transact-SQL programming fundamentals – (Part 1) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learn how to use scripts and batches, and basics of Transact-SQL variables. SQL Server users use Transact-SQL programming to create sets of statements for ad hoc execution. The aim of the Transact-SQL programming is to carry…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register