Adding a column to the desired position

--Addition of table column on specific location (order)
--Actual Table: updateAccount
--Addition of column on 3rd position: Misc_Details

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_updateAccount
      (
      sk_accountant int NULL,
      nk_accountant varchar(10) NULL,
      Misc_Details nchar(30) NULL,
      Accountant char(30) NULL
      )  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_updateAccount SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.updateAccount)
       EXEC('INSERT INTO dbo.Tmp_updateAccount (sk_accountant, nk_accountant, Accountant)
             SELECT sk_accountant, nk_accountant, Accountant FROM dbo.updateAccount WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.updateAccount
GO
EXECUTE sp_rename N'dbo.Tmp_updateAccount', N'updateAccount', 'OBJECT'
GO
COMMIT