GUID

In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.

2020-11-11

GUIDs GUIDs everywhere, but how is my data unique?

After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(40)

You rated this post out of 5. Change rating

2014-12-18

10,064 reads

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-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;