title: how to convert GUID INTO int in sql database
body: <p>I have mentioned below table same I need to convert the [uniqueidentifier] to int values in entire database corresponding related tables as well. what is the best approach to implement this into production without impact ?</p>
  
  <pre><code>CREATE TABLE [usp].[Test]( [AccountId] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Account_AccountId] DEFAULT (newsequentialid()), [AccountName] nvarchar NOT NULL, [AccountDescription] nvarchar NULL, [AccountStatusId] [uniqueidentifier] NOT NULL, [AccountTypeId] [uniqueidentifier] NOT NULL, [GeoLocation] varchar NULL, [ContactInfoId] [uniqueidentifier] NULL, [ParentId] [uniqueidentifier] NULL, [Encoding] varchar NOT NULL, [IsDeleted] [bit] NULL DEFAULT ((0)), [AccountHeirarchy] nvarchar NULL,
  
  CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED ( [AccountId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  </code></pre>
  
  <p>values examples below.</p>
  
  <pre><code>AccountId AccountName AccountDescription AccountStatusId AccountTypeId GeoLocation ContactInfoId ParentId Encoding IsDeleted AccountHeirarchy HID
  
  A70D7DCE-4F1F-E211-AAA2-0050568F021A SysAccount Administrator Account A0000000-0000-0000-0000-000000000000 A70D7DCE-4F1F-E211-AAA2-0050568F021B NULL NULL NULL 1 0 NULL
  </code></pre>