Optional vs Required parameters in Stored Procedures
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
185 reads
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
185 reads
I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to...
2019-07-29
93 reads
Introduction Leila Etaati is an AI MVP, mentor, trainer, speaker and consultant. She spoke in some important conference such as Microsoft USA Ignite, Microsoft Data Insight Summit, SQL PASS,...
2019-07-26
38 reads
Spotify implemented a way to get your data from your profile. This looks at the request and initial data download. The Request When you go there, you see a...
2019-07-26
48 reads
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
316 reads
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
22 reads
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
49 reads
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
163 reads
There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio. You can use the query editor...
2019-07-25
28 reads
Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They’re something that I’ve found myself explaining time and time again, I’ve even...
2019-07-25
680 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers