Quick and hassle free method of viewing the existing or non-existant primary keys in your database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2005-11-16 (first published: 2005-10-28)

253 reads

Blogs

Next week I’m at VS Live in San Diego (register and join me) and...

Ten years ago today, I filmed a Pluralsight Play by Play on open source...

It’s time for T-SQL Tuesday again and this is a great prompt to start...

Forums

Comments posted to this topic are about the item Stored Procedures for Server-Level Object...

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)