SELECT
B.Id,
B.[Name],
B.UserId,
DateTimeO =
SWITCHOFFSET(
CONVERT(datetimeoffset, B.[Date]),
'+12:00')
INTO dbo.NewBadges
FROM dbo.Badges AS B;
DROP TABLE dbo.Badges;
ALTER TABLE dbo.NewBadges
ADD CONSTRAINT [PK dbo.NewBadges Id]
PRIMARY KEY CLUSTERED (Id);
EXECUTE sys.sp_rename
@objname = N'dbo.NewBadges',
@newname = N'Badges',
@objtype = 'OBJECT';
EXECUTE sys.sp_rename
@objname = N'[PK dbo.NewBadges Id]',
@newname = N'PK dbo.Badges Id',