Dan Ryan

Enforce business rules with indexed views and a two-row table

Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(41)

You rated this post out of 5. Change rating

2012-08-20

8,204 reads

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

Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

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

Comments posted to this topic are about the item UNISTR Basics

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

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