John Rogerson

List instances hosting similarly named databases

Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2 (4)

You rated this post out of 5. Change rating

2016-06-03 (first published: 2016-05-06)

340 reads

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

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

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

Vehicle loan ads are a powerful tool for increasing loan application rates by attracting...

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

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

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 '\'