TheSQLPro

Ayman is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. From there, he moved up to computer programming in high school and went on to get B.S. and M.S. degrees in Information Systems from Drexel University in Philadelphia. He has worked with the SQL Server product since 2006 and has experience with SQL 2000 through SQL 2012. He holds a MCITP SQL 2008 DBA certification and is also a Microsoft Certified Trainer (MCT. He has been active with the virtual chapters of PASS, participating in online training and also giving presentations. Ayman has lived in many different countries around the world including the U.S., U.K., Egypt, Saudi Arabia and speaks fluent Arabic. He is huge football(soccer) fan and is always looking forward to learn more about SQL Server, SQL Server BI, and technology in general. www.thesqlpro.com

Blogs

My Social Media Rules

By

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

A Guatemalan's Guide to Drinking Coffee Properly

By

My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...

Read the latest Blogs

Forums

Partitioning a table with TEXTIMAGE_ON option

By Brandie Tarvin

I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...

ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145

By m4l4mt194

WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...

OUTER APPLY Fundamentals: Part 2

By Imran2629

Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2

Visit the forum

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          1
If I run this query, how many rows are returned?
SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

See possible answers