2,560
Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...
2012-10-23
1,429 reads
Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...
2012-10-23
1,429 reads
When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult...
2012-09-22
793 reads
In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...
2012-08-24
1,580 reads
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,007 reads
This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122....
2012-07-24
983 reads
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
856 reads
In my previous post, I shared some of the issues I had when attempting to get Add-Member to work with...
2012-07-05
1,485 reads
Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...
2012-07-04 (first published: 2012-06-28)
3,930 reads
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,666 reads
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,424 reads
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
Code that can be used in order to create dashboard or SSRS report on...
So, I have an interesting situation that I need a double-check on. One of...
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers