Defensive Db Programming Chapter 09
It is down to the final two chapters of the book by Alex Kuznetsova. Check out the previous chapter here. The review of this book is certainly taking longer...
2010-11-22
6 reads
It is down to the final two chapters of the book by Alex Kuznetsova. Check out the previous chapter here. The review of this book is certainly taking longer...
2010-11-22
6 reads
It is down to the final two chapters of the book by Alex Kuznetsova. Check out the previous chapter here....
2010-11-22
967 reads
As I was doing a little research this evening for a client, I hit the SQLMag site for the latest updates. ...
2010-11-22
653 reads
Hey folks – It’s time again for SQL Saturday Tampa. Original Birthplace of Iron Chef SQL Server. I have submitted this...
2010-11-22
591 reads
Hey folks, Just a quick preview that we’re hard at work again on a new book with Wiley publishing focused...
2010-11-22
426 reads
Hey folks, we all know that there are some great training organizations out there (AHEM Pragmatic Works, AHEM). I hate...
2010-11-22
410 reads
Have you ever had to take a long column of data in Excel and turn it into a column? There...
2010-11-22
372 reads
Hey folks – A quick one today since I’m travelling, but I am sharing something I often share with my clients...
2010-11-22
536 reads
Today is a topic that is close to my heart. Many of you probably don’t know that the SQL pass...
2010-11-22
542 reads
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server...
2010-11-22
762 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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