LOWER() function in SQL Server
LOWER():- This function is used to convert the value of a column to lower case
Syntax:-
Select LOWER (string)
or
SELECT LOWER(column_name) FROM table_name
For...
2014-08-14
591 reads
LTRIM() function in SQL Server
LTRIM ():- This function is used to get the string after the removal of leading blank spaces.
Syntax:-
LTRIM ( character_expression )
For example:-
Select LTRIM ...
2014-08-14
434 reads
Substring() function in SQL Server
Substring():- This function is used to return the specified number (third argument "len") of characters from a given string(first argument)...
2014-08-14
962 reads
SQL Server UG in Vegas August 2014 Meeting
Another Great meeting and topic is coming to the folks in Las Vegas. This month we have had the luck of finding Mike Fal (blog | twitter) step...
2014-08-14
11 reads
SQL Server UG in Vegas August 2014 Meeting
Another Great meeting and topic is coming to the folks in Las Vegas. This month we have had the luck...
2014-08-14
686 reads
One of Those Must Read Books – The Cuckoo’s Egg
I was reading a book about network security monitoring and it mentioned The Cuckoo’s Egg by Cliff Stoll. Stoll’s book has been...
2014-08-13
522 reads
The Murder Train chugs into Denver!
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-08-13
680 reads
SQL Server for VM Admins vBrownBag Webinar
Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL...
2014-08-13
616 reads
Tableau Conference Is Bigger Than PASS Summit
I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe, I was astounded to see that...
2014-08-13
514 reads
Max() function in SQL Server
Max():- This function gives the maximum value of the selected column
Syntax:-
Select Max (col1) from table_name
In this article, we are...
2014-08-13
844 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers