Andy Warren

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

SQLServerCentral Editorial

We Want Maturity, But Is It Fun?

Today we have a guest editorial from Andy Warren as Steve is away on vacation. This was originally published on Dec 23, 2014. I was reflecting recently on my first real IT job. It was a small-ish company when I joined it, perhaps a hundred employees or so, and still using a mishmash of software […]

You rated this post out of 5. Change rating

2019-02-18 (first published: )

198 reads

Blogs

Advice I Like: Apologies

By

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Build a Serverless Todo App With AWS, Pulumi, and Python

By

Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...

Master SQL Subqueries with This Free Course

By

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

Read the latest Blogs

Forums

SQL Query to use in MS SSRS server to give you your report structure.

By wolfsvein

Code that can be used in order to create dashboard or SSRS report on...

Temp table security

By Brandie Tarvin

So, I have an interesting situation that I need a double-check on. One of...

Hello sqlserer centrel

By queens

I am new here and will like to learn as days goes

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