Sql Functions

Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2023-11-20 (first published: 2023-11-15)

13,401 reads

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2020-10-07 (first published: 2020-09-08)

44,061 reads

There's a great article from MIT Technology Review about resetting on the hype of...

etherness – n. the wistful feeling of looking around a gathering of loved ones,...

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Comments posted to this topic are about the item The Microsoft SQL Year in...

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Comments posted to this topic are about the item Your Value from a Conference

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';