Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,486 reads
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,486 reads
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
176 reads
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
1,023 reads
With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...
2018-04-11
455 reads
Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...
2018-04-11
19 reads
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
784 reads
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the...
2018-04-11
19 reads
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton...
2018-04-11
321 reads
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
974 reads
[read this post on Mr. Fox SQL blog] Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DW. Seems simple...
2018-04-10
25 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
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