Listing 1: Stored Procedure That Generates a New GUID

CREATE PROCEDURE guidgen
  @guid VARCHAR(36) = NULL
AS
SET @guid = right(newid(),12)
SELECT @guid
GO