roger.plowman (8/4/2016)

---

Mononymics are fairly straightforward as far as I'm concerned.

The mononymic would go in the given/first name and "N/A" would go in the family name.

Also, nulls are abominations, since...

😀

If there's a need...

Tom Gillies (8/4/2016)

---

That's definitely an interesting and useful suggestion. Tung has pointed out a real problem. The difficulty with dealing with it in the abstract is that different solutions work...

Ernie Schlangen (8/4/2016)

---

Allow me to propose an alternative. One of the primary reasons Western databases store names in multiple fields (given_name, surname, title, etc.) is to allow for the...

robert.sterbal 56890 (8/4/2016)

---

I would not want to type the column prefix column names you suggested.

For an article thorough about a lot of things, the assumption that you would name columns...

szeitzp (8/4/2016)

---

1. The full_name column may not a practical one. It is brings more problem than profit, if you think about the possible sequences of the first_name and last_name it...

Tom, yes indeed, my name is a mononym. I still...

BTW, that last INSERT should be:

INSERT INTO demo.Customers_5(

cst_full_name

, cst_full_name_native_language

, cst_short_name

, cst_short_name_native_language

)

VALUES ('Tyrion Lannister',N'Tyrion Lannister','Tyrion',N'Tyrion')

, ('Lee Jun-fan',N'???','Bruce',N'??')

, ('Sinéad O''Connor',N'Sinéad O''Connor','Sinéad',N'Sinéad')

, ('Cher',N'Cher','Cher',N'Cher')

, ('Nebuchadnezzar',N'????????','Nebuchadnezzar',N'????????')

, ('Gordon Matthew Thomas Sumner',N'Gordon Matthew Thomas...

Have you already tried RedGate's SQL Prompt?