T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
901 reads
SQLServerCentral.com Track at Orlando SQL Server Connections
This past week, about 1,200 developers, IT professionals, and DBAs spent three days attending DevConnections at the J.W. Marriott Resort...
2011-04-01
784 reads
SQL in the City: Free SQL Server Events in London and Los Angeles
Red Gate Software has announced two free, full-day SQL Server events, called “SQL in the City”. Both events will provide...
2011-04-01
773 reads
April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
599 reads
A 22 Hour Layover
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
852 reads
Changing Directions
I See Dead Tech….
Knowing when a technology is dying is always a good skill to have. Like most of my...
2011-04-01
921 reads
Word Macro to load a Data Warehouse
Recently I came across a very specific requirement for a Data Warehouse project for one of our customers. Due to...
2011-04-01
556 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
401 reads
SQL Saturday 63 Dallas: EPICITY
SQL Saturday 63 Dallas. Will. Be. Epic.
Here are my proofs:
The Schedule. Note the gelato breaks. It is impossible to get...
2011-04-01
510 reads
Powershell Day 1
Day 1 Introduction to Powershell I got inspired by great people like Paul Randal and Glenn Berry and decided to...
2011-04-01
823 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers