One of the newer features in Data Masker for SQL Server is the ability to read column classifications and suggest rules to clean the data. I decided to give...
2019-12-02 (first published: 2019-11-22)
273 reads
We have just published SQL Saturday Rochester 2020. We took last year off but we’re back for 2020 on a very special day - it’s Leap Day, February 29th!
What...
2019-11-22
10 reads
It is that time of year again. The NTSSUG has two spots coming open on the board. Last year I decided at the last minute to opt in as...
2019-11-21
8 reads
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the point? What...
2019-11-21
24 reads
Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use...
2019-11-21
5 reads
Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use...
2019-11-21
7 reads
Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use...
2019-12-04 (first published: 2019-11-21)
330 reads
Welcome back to my Power Platform Quick Tips series! In this second episode we look how to return back a dynamic header or title for
2019-12-03 (first published: 2019-11-21)
320 reads
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of being a guest Author and explain Azure storage options. I cover types of storage accounts,...
2019-11-20
145 reads
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month.
The post T-SQL Tuesday #120 – Recap appeared first on Wayne Sheffield.
2019-11-20
14 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