DBA On The Go

We all love our databases. We trust everything they do! How could we not? It's our baby.... well, probably not....

2013-11-07

313 reads

How to find empty tables in SQL Server : Quick Tip

These quick tips are short and sweet. They are nothing more than an explanation and some code. If you have...

2013-11-06

553 reads

I've been to five SQL Saturdays so far and this was my first year to attend the Dallas conference. Therewere...

2013-11-06

407 reads

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

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

How I used AI for this postChatGPT to generate images based on info specifically...

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

Comments posted to this topic are about the item RegEx Functions II

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)