Microsoft SQL Server 2000
Best Practices
This is a hotly debated issue in database design and modelling.
There are 2 ways:
1. ID
The advantage of this that in a join you can tell which is the primary key.
2. TableXID
This has the advantage of satisfying tools which are doing automatic matching of primary keys and foreign keys.