SQLStudies

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...

2012-09-02

4,135 reads

At Startup SSMS setting

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

672 reads

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,351 reads

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...

A few years ago I took a new job at Microsoft, working as a...

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...

Comments posted to this topic are about the item Building a SQL Server Fleet...

Comments posted to this topic are about the item Smart AI Agents and Data...

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

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

EmailAddressID EmailAddress
7              [email protected]
8              [email protected]

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

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