Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,369 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,369 reads
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
620 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,654 reads
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
680 reads
Andy Warren recommended The Checklist Manifesto to me and after seeing his review, I decided to grab it. It’s written...
2010-11-26
1,851 reads
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
979 reads
Yesterday, I have received the official email from the PASS HQ, and the confirmation that now I'm the leader of...
2010-11-25
821 reads
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.In previous...
2010-11-24
672 reads
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,182 reads
Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what...
2010-11-24
587 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