My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

All authors

All authors

Blogs

Master SQL Subqueries with This Free Course

By

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Removing the REST Endpoint in the Data API Builder

By

The more I work with the Data API Builder (DAB), the more I lean...

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

Read the latest Blogs

Forums

Vector DB implementation using FAISS

By utsav

Comments posted to this topic are about the item Vector DB implementation using FAISS

The Types of Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Types of Changes

Escaping Like I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Escaping Like I

Visit the forum

Question of the Day

Escaping Like I

I have this data in a SQL Server 2022 table: 

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive
How many rows are returned by this code in SQL Server 2022? 
select PlayerName from player
where playername like 'The\_C%' escape '\'
 

See possible answers