title: Insert record with uniqueidentifier column
body: <p>I want to insert new records into a table called <code>[dbo].[Local]</code> that has these columns:</p>
  
  <pre><code>[id] [uniqueidentifier] NOT NULL,
  [Component] [varchar](100) NULL,
  [Language] [varchar](10) NULL,
  [IsText] [bit] NULL,
  [key] [varchar](100) NULL,
  [value] [varchar](max) NULL,
  </code></pre>
  
  <p>And the primary key called [id] is key clustered as:</p>
  
  <pre><code>[id] ASC) 
  WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
        IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  </code></pre>
  
  <p>The insert command is like shown below. But how can I set a value for the <code>[id]</code> column because I get an error when I try to enter the value in the <code>[id]</code> column.
  How can I insert value to this field automatically? </p>
  
  <pre><code>INSERT INTO [dbo].[Local] ([id], [Component], [Language], [IsText], [key],[value])
  VALUES (00000000-0000-0000-000-00000000000, 
          'Transport.Web', 'en', 1, 'ResourceTypeEmployee', 'TypeOffice')
  GO
  </code></pre>
  
  <p>Thanks</p>