Forum: Computer Science Feb 27th, 2008 |
| Replies: 6 Views: 1,450 To be honest, I am not entirely sure. I do not believe that it would help with search speed in this example. It seems to be standard practice that every table have an IDENTITY column that serves... |
Forum: Computer Science Feb 25th, 2008 |
| Replies: 6 Views: 1,450 I think you want to introduce a third table.
CREATE TABLE Moves
(
MoveID int IDENTITY NOT NULL PRIMARY KEY,
Date datetime NOT NULL
)
CREATE TABLE Items
( |