views:

784

answers:

5

I've seen this abbreviation (or mnemonic) used in various examples in SQL and web services.

What does it mean? And if you know, what are its origins?

+10  A: 

It's the unique key of "Alfreds Futterkiste", the first "Customers" table entry in Microsoft's "Northwind" sample database that ships with SQL Server.

Tomalak
+2  A: 

It's a sample customer in Microsoft supplied Northwind database (used for tests)

Quassnoi
+9  A: 

'ALFKI' is the primary identifier of a known Customer record in the Northwind sample Database from Microsoft.

It is used here and there almost as "foobar" is used as a canonical variable name.

Denis Troller
+2  A: 

Customer key from the Northwind sample database that Microsoft used over the years.

Jon Masters
+15  A: 

It's the primary key (CustomerID) of the First Customer entry in the Microsoft Northwind Demo Database

ALFKI   
Alfreds Futterkiste 
Maria Anders    
Sales Representative    
Obere Str. 57   Berlin  
12209   
Germany 
030-0074321 
030-0076545
Eoin Campbell
Ha! I thought I was missing something, reviewing code and thought I was losing it.
Jess