Column alias in order by and where
If you ever wonder why column alias can be used in order by and not in where clause, it’s the...
2011-11-08
6,950 reads
Blog Posts
CONVERT Dates and Confusion
Right I've been itching to post another Blog and actually contribute something this time. This isn't something I've learned but something I've taught many...
2011-11-08
795 reads
How much space are you wasting?
A few weeks back a client of mine asked me to write a script that could tell him the space...
2011-11-08
864 reads
Inline TVFs can't use FORCE ORDER hint but Multi-Statement TVFs can...?
Doing some work with converting Multi-Statement TVFs to Inline TVFs and I'm finding that the Inline TVFs cannot use the...
2011-11-08
686 reads
My Playbook For Putting On a SQLSaturday Part 1
The Long Road
I am going to post this as a series covering, in detail, everything humanly possible about the logistics...
2011-11-08
1,286 reads
PASS Board Of Directors Interview
I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...
2011-11-08
633 reads
Quite a salary
If this article is true, and I suspect it is for some software engineers, why aren’t more people learning programming?
I...
2011-11-08
1,065 reads
SQL Saturday #99 Minnesota on Friday 11/11/11
SQL Saturday 99 on Friday is upon us. I look forward to seeing you at the event. For details check...
2011-11-08
405 reads
SQL Server security webinar now available on-demand
Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...
2011-11-08
1,166 reads
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,792 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Alamat Kantor BCA KCU GRESIK Telp/Wa (0817)839777)
Kontak Cs: 0817839777 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik,...
Alamat Kantor BCA KCU VETERAN ??/Wa (0817)839777
Kontak Cs: 0817839777 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Alamat BCA KCU Mojokerto ??/Wa (0817)839777
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers