title: SQL insert into related tables
body: <p>This seems to me to be the kind of issue that would crop up all the time with SQL/database development, but then I'm new to all this, so forgive my ignorance.</p>
  
  <p>I have 2 tables:</p>
  
  <pre><code>CREATE TABLE [dbo].[Tracks](
      [TrackStringId] [bigint] NOT NULL,
      [Id] [bigint] IDENTITY(1,1) NOT NULL,
      [Time] [datetime] NOT NULL,
   CONSTRAINT [PK_Tracks] PRIMARY KEY CLUSTERED 
  (
      [Id] ASC
  ) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF,
          IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON,
          ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  ALTER TABLE [dbo].[Tracks] CHECK CONSTRAINT [FK_Tracks_AudioStreams]
  GO
  
  ALTER TABLE [dbo].[Tracks]  WITH CHECK ADD  CONSTRAINT
  [FK_Tracks_TrackStrings]     FOREIGN KEY([TrackStringId])
  REFERENCES [dbo].[TrackStrings] ([Id])
  GO
  
  ALTER TABLE [dbo].[Tracks] CHECK CONSTRAINT [FK_Tracks_TrackStrings]
  GO
  </code></pre>
  
  <p>and</p>
  
  <pre><code>CREATE TABLE [dbo].[TrackStrings](
      [Id] [bigint] IDENTITY(1,1) NOT NULL,
      [String] [nvarchar](512) NOT NULL,
   CONSTRAINT [PK_Strings] PRIMARY KEY CLUSTERED 
  (
      [Id] ASC
  ) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF,
          IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON,
          ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  
  <p>I want to insert a new entry into the tracks table. This will also involve inserting a new entry in the trackstrings table, and ensuring that the foreign key column trackstringid in tracks points to the new entry in trackstrings.  What is the most efficient means of achieving this?</p>