tSQLt Visual Studio Test Adapter
tSQLt Visual Studio Test Adapter What is this? This lets you use Visual Studio to run tSQLt tests easily. Visual...
2016-08-17
52 reads
Ed Elliott's Sql Developer Blog
tSQLt Visual Studio Test Adapter
tSQLt Visual Studio Test Adapter What is this? This lets you use Visual Studio to run tSQLt tests easily. Visual Studio has a built in framework for finding and...
2016-08-17
7 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
882 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
43 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
44 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
24 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open a dacpac, compare to a database and either create...
2016-08-02
2 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where...
2016-05-05
597 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let’s you identify where...
2016-05-05
45 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let’s you identify where...
2016-05-05
42 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