title: Problems with Data Script Generation
body: <p>I very rarely use SQL Server and in a professional context I keep well clear!  I'm working on a pet project though and I'm have problems with a script creation.</p>
  
  <p>I've got an online database that I need to extract everything out of.  I use the Tasks > Generate Scripts option within SQL Server Management Studio. The following is an example of one insert statement the script creates (I have 1,000s of these inserts):</p>
  
  <pre><code>INSERT [dbo].[NewComics] ([NewComicId], [Title], [Subtitle], [ReleaseDate], [CollectionId]) VALUES (366, N'Hawk &amp; Dove 1:                                                                                      ', N'First Strikes                                                                                       ', CAST(0x00009F6F00000000 AS DateTime), 248)
  </code></pre>
  
  <p>I have two issues with this:</p>
  
  <p>(a) I want to strip all the whitespace from the two title elements
  (b) I don't want a HEX date - I want something readable like 2006-09-01 (yyyy-mm-dd)</p>
  
  <pre><code>INSERT [dbo].[NewComics] ([NewComicId], [Title], [Subtitle], [ReleaseDate], [CollectionId]) VALUES (366, N'Hawk &amp; Dove 1:', N'First Strikes', '2006-09-01', 248)
  </code></pre>
  
  <p>What would be the quickest way to change about 3,000 insert statements to this revised format?</p>
  
  <p>FYI - this is the design of the table:</p>
  
  <pre><code>[NewComicId] [int] NOT NULL,
  [Title] [nchar](100) NOT NULL,
  [Subtitle] [nchar](100) NULL,
  [ReleaseDate] [datetime] NOT NULL,
  [CollectionId] [int] NOT NULL,
  </code></pre>
  
  <p>Thanks in advance!</p>