title: Return NEWSEQUENTIALID() as an output parameter
body: <p>Imagine a table that looks like this:</p>
  
  <pre><code>CREATE TABLE [dbo].[test](
       [id] [uniqueidentifier] NULL,
       [name] [varchar](50) NULL
  )
  
  GO
  
  ALTER TABLE [dbo].[test] ADD  CONSTRAINT [DF_test_id]  DEFAULT (newsequentialid()) FOR [id]
  GO
  </code></pre>
  
  <p>With an <code>INSERT</code> stored procedure that looks like this:</p>
  
  <pre><code>CREATE PROCEDURE [Insert_test]
      @name as varchar(50),
      @id as uniqueidentifier OUTPUT
  AS
  BEGIN
      INSERT INTO test(
          name
      )
      VALUES(
          @name
      )
  END
  </code></pre>
  
  <p>What is the best way to get the GUID that was just inserted and return it as an output parameter?</p>