sql server programming: Not much to comment on, except that an artificial key should not be the only
key of a table. So you should probably make Title unique as well.

--
David Portas
SQL Server MVP
--

Hi,

Do you see the following sample as "smart".
----------------------------------------------------------
| ID (int32) | Code (uniqueidentifier) | Title (nvarchar) | ... |
----------------------------------------------------------

ID is the key. I use this key also as foreignkey in other tables.
I want to use Code as an id for the URL.

What do you think about this?

Thanks!

Okay, this was just a sample for a news table, where title is the title of
the newsitem (It can be unique...).

Thanks!
Arjen



"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> schreef in bericht
news:7a-dnT0US4peWTffRVn-hg@giganews.com...
[quoted text, click to view]