SQL Server 2011 - Code Name "Denali" & BOL
Many information via Twitter, LinkedIN, forums, blogs, including also here in SSC, have announced about new incmoing version of the...
2010-11-09
883 reads
Many information via Twitter, LinkedIN, forums, blogs, including also here in SSC, have announced about new incmoing version of the...
2010-11-09
883 reads
Just for info that the incoming 24 Hours of PASS now has bonus sessions ...you can check for the details...
2010-09-10
724 reads
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
647 reads
Another free tool for SQL Server that supports SQL Server 2008/2005/2000, comes from xSQL Software, the Script Executor Commnity Edition,...
2010-09-03
1,188 reads
For a long time I haven't been active member at SSC, so I'm coming back again, saying once again Hello...
2010-09-03
609 reads
Getting Started with SQL Azure - Very nice & short document about SQL Azure beginning process. This is the official document that...
2010-07-07
1,292 reads
Using the command prompt for stopping and starting services is a very nice possibility and very fast! We know that...
2010-06-23
17,358 reads
Microsoft, has published things that can be very useful, in this case for the SQL Server users. They announced the...
2010-06-22
3,728 reads
Two of the biggest events in the Technology World will be held at the same date!
PASS SUMMIT 2010 (8-11, November...
2010-06-10
740 reads
On June 9, 2010 is held the annual event that in Prishtina is recognized as Microsoft TechUpdate. Presenters in this...
2010-06-09
1,847 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