Listing 5: Stored Procedure That Swaps the Seed Value with Another GUID

CREATE PROCEDURE sessvars_upd_guid
  @guid varchar(12),
  @new_guid varchar(12)
AS
UPDATE sessvars
SET GUID = @new_guid
WHERE GUID = @guid
GO