October 21, 2012 at 1:59 am
I need to add records to a DB in SQL Server 2005.
Each composite record represents a project in the table PROJECT, with client and agent addresses in the table ADDRESS, with foreign keys Client_addr_id and Agent_addr_id and primary key Addr_id in ADDRESS.
Can someone show me how to add the composite record in one transaction, please?
(I'm doing this from Access 2007 using DAO/ODBC, but presumably that doesn't make much different to the principles of what I'm trying to do.)
Andrew
October 22, 2012 at 7:16 am
You don't need to duplicate your posts 😉
http://www.sqlservercentral.com/Forums/Topic1375152-1292-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply