How would you design a table (or tables) ... Incidentally, if I was using SQL Server 2005 (or any database that supports XML as a colunmn-type and supports XPath/XQuery) ...

trying to design a generic file attachment table(s) for some business objects we keep in sql 2008 r2. files will be stored on disk and i'm not really interested in keeping them in the database.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Basically, you’ll want to enable system-versioning for the source table to a history table which you’ve decided will be temporal. That being the case, you’ll need a couple additional columns of ...