Announcing the fifth certification study session
The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...
2011-04-23
1,260 reads
Announcing the fourth certification study session
The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...
2011-04-23
867 reads
Welcome to SQLREPL
Hi everyone. Welcome to my new blog. I’m still in the building stages here so things may seem a little...
2011-04-23
625 reads
A SQL Server Hardware Nugget A Day – Day 22
For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related...
2011-04-23
759 reads
PowerShell Tip – Custom windows for different tasks.
G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...
2011-04-22
741 reads
Powershell Day 23
Day 23 SMO programming Part 4 AS we can work with Server, Database, Table, Column. You can get the similar...
2011-04-22
368 reads
What Don’t I Know?
Apparently a lot, at least according to the blooper reel today
Filed under: Blog Tagged: bloopers, Humor, syndicated
2011-04-22
748 reads
Re-Blog – April 15-21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-22
575 reads
Powershell Day 22
Day 22 SMO programming Part 3 In earlier blog we have discussed about server and database classes, using table clase...
2011-04-22
517 reads
If a web page asks you to update Adobe Flash Player
You don't want to do so from that web page. Instead you want to go to the Adobe web site...
2011-04-22
1,132 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
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