The SQLServerCentral.com Reader's Choice Awards voting has begun. Vote for the product or book that you feel is best in breed and saves you the most time. Voting is simple and takes less than a minute.
2002-06-24
105 reads
Want to be an author and be admired by the SQL Server community? Find out more details about how to be a writer for SQLServerCentral.com, visit this page.
2002-06-19
42 reads
The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics.
2002-06-19
4,470 reads
This week, SQLServerCentral.com launched its Resource Center all about getting a sneak peak on Yukon. All links are user contributed.
2002-06-14
24 reads
Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.
2002-06-10
25 reads
LockwoodTech announces release of Auto-Audit 2.0, an entirely redesigned upgrade to it's popular SQL Auditing tool. Version 2.0 supports plug-in, customized audit architectures, scriptable trigger templates, a trigger and data management module, real data reports, and online analysis of audit data with grouping analysis.
2002-06-04
3,524 reads
The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java™ environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.
2002-05-29
3,342 reads
SQL Spy 4.0 is a program that lets you monitor your server real time to look for locking problems, unusual user activity or users that are using large amounts of your server resources. The program is like SQL Profiler in a tighter, easier package.
2002-05-22
150 reads
It provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the web interface. Members can now download this as Freeware at SQLServerCentral.com.
2002-05-16
130 reads
SQLServerCentral.com has crossed 40,000 users! Thanks for all of you telling your friends about our site and making us a strong SQL Server community. To thank you, you can request to receive a free DTS object model poster that we worked on in conjuction with Lumigent. To sign up to get your hard copy, go to http://www.lumigent.com/go/sqlcentral05
2002-05-10
3,336 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
Comments posted to this topic are about the item 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