Microsoft Data Platform and PowerShell MVP, Chrissy Lemaire (b|t) sat down with us in the virtual studio Saturday, and we had a blast getting to know her! Quotables: “This...
2020-05-28 (first published: 2020-05-18)
328 reads
The general idea for this question came from dba.stackexchange.com: could we, and if we can, how, get row counts after execution. I was intrigued with the idea, so I...
2020-06-01 (first published: 2020-05-18)
603 reads
I’ve always wanted to go to Australia, in fact we have a trip planned for Martin’s 60th birthday in a couple of years. But with all that’s happened in...
2020-05-18
61 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-18
16 reads
SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...
2020-06-01 (first published: 2020-05-18)
241 reads
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 ... Continue reading
2020-05-18
414 reads
Thank you, everyone, to stay along with me on this journey. I started this blog for the self repository of SQL Server knowledge articles, Later I made it public...
2020-05-18
35 reads
So you’ve decided to use Azure for your existing or new data project? This blog series is focused on choosing the right technology for your project. It’s tough right?...
2020-05-28 (first published: 2020-05-17)
789 reads
In the last post, we have discussed the DTU purchase model. Azure also provides another purchase mode which is called vCore. vCore purchase model available with all three deployment...
2020-05-17
11 reads
In the last post, we have discussed the DTU purchase model. Azure also provides another purchase mode which is called vCore. vCore purchase model available with all three deployment...
2020-05-26 (first published: 2020-05-17)
840 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
Comments posted to this topic are about the item The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers