Hi Rick,
If I understand you correctly your sub table and main table need to be
linked by a shared column or columns so that it is possible to find the
row in the sub table that relates to the row in the main table.
The first step is to establish what this will be. If (as your post
suggests)
If you're using MS SQL Server 2k you can use an identity
column in the related table and use the scope_identity()
function to return the value inserted into the column from a
stored procedure. That's the most efficient way if you're
using SQL Server 2000...
If you're using Oracle or another DB
No help whatsoever but for future reference:
This arrangement is sometimes referred to as a Vertical Partition as
opposed to Horizontal Partitions which is what you might use for
archiving data etc.
Vertical Partitions are definitely worth considering for saving space if
the circumstances are
3 matches
Mail list logo