SQL SERVER – Completo script con las zonas horarias

Por si alguien lo necesita, publico el script que me permite crear una tabla en la base de datos y luego insertar todas las zonas horarias.

CREATE TABLE [dbo].[cmon_timezone](
    [timezoneid] [int] IDENTITY(1,1) NOT NULL,
    [title] [varchar](500) NOT NULL,
    [OffSet] [decimal](4, 2) NOT NULL,
    CONSTRAINT [PK_cmon_timezone] PRIMARY KEY CLUSTERED 
(
    [timezoneid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ahora el script para insertar las zonas horarias:

SET IDENTITY_INSERT [dbo].[cmon_timezone] ON
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (1, N'Islas Marshall (Hora de cambio de fecha, GMT-12:00)', CAST(-12.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (2, N'Estado Independiente de Samoa (Hora de Samoa, GMT-11:00)', CAST(-11.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (3, N'Honolulu (Hora de Hawái, GMT-10:00)', CAST(-10.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (4, N'Anchorage (Horario de verano de Alaska, GMT-08:00)', CAST(-8.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (5, N'Arizona (Hora de la montaña de Estados Unidos, GMT-07:00)', CAST(-7.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (6, N'San Francisco (Horario de verano del Pacífico, GMT-07:00)', CAST(-7.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (7, N'Tijuana (Horario de verano de la costa del Pacífico de México, GMT-07:00)', CAST(-7.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (8, N'Chihuahua (Horario de verano de la Montaña de México, GMT-06:00)', CAST(-6.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (9, N'Denver (Horario de verano de la montaña, GMT-06:00)', CAST(-6.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (10, N'Saskatchewan (Hora del centro de Estados Unidos, GMT-06:00)', CAST(-6.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (11, N'Tegucigalpa (Hora de Honduras, GMT-06:00)', CAST(-6.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (12, N'Bogotá (Hora de la costa del Pacífico de Sudamérica, GMT-05:00)', CAST(-5.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (13, N'Chicago (Horario de verano del centro de Estados Unidos, GMT-05:00)', CAST(-5.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (14, N'Ciudad de México (Horario de verano de México, GMT-05:00)', CAST(-5.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (15, N'Caracas (Hora de Sudamérica Occidental, GMT-04:30)', CAST(-4.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (16, N'Indiana (Horario de verano del este, GMT-04:00)', CAST(-4.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (17, N'La Paz (Hora de Sudamérica Occidental, GMT-04:00)', CAST(-4.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (18, N'Nueva York (Horario de verano del este, GMT-04:00)', CAST(-4.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (19, N'Brasilia (Hora estándar del este de Sudamérica, GMT-03:00)', CAST(-3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (20, N'Buenos Aires (Hora del este de Sudamérica, GMT-03:00)', CAST(-3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (21, N'Halifax (Horario de verano del Atlántico, GMT-03:00)', CAST(-3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (22, N'Recife (Hora del este de Sudamérica, GMT-03:00)', CAST(-3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (23, N'Newfoundland (Horario de verano de Terranova, GMT-02:30)', CAST(-2.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (24, N'Nuuk (Horario de verano de Groenlandia, GMT-02:00)', CAST(-2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (25, N'Atlántico Medio (Horario de verano del Atlántico Medio, GMT-01:00)', CAST(-1.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (26, N'Azores (Horario de verano de las Islas Azores, GMT)', CAST(0.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (27, N'ReykjavÍk (Hora de Greenwich, GMT)', CAST(0.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (28, N'Casablanca (Horario de verano de Marruecos, GMT+01:00)', CAST(1.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (29, N'Londres (Horario de verano de GMT, GMT+01:00)', CAST(1.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (30, N'África Occidental (Hora de África Occidental, GMT+01:00)', CAST(1.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (31, N'Ámsterdam (Horario de verano de Europa, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (32, N'Berlín (Horario de verano de Europa, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (33, N'El Cairo (Hora de Egipto, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (34, N'Madrid (Horario de verano de Europa, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (35, N'París (Horario de verano de Europa, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (36, N'Pretoria (Hora de Sudáfrica, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (37, N'Roma (Horario de verano de Europa, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (38, N'Estocolmo (Horario de verano de Suecia, GMT+02:00)', CAST(2.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (39, N'Amman (Horario de verano de Jordania, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (40, N'Atenas (Horario de verano de Grecia, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (41, N'Helsinki (Horario de verano de Europa del Norte, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (42, N'Istanbul (Horario de verano de Europa del Este, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (43, N'Nairobi (Hora de Nairobi, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (44, N'Riyadh (Hora de Arabia Saudita, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (45, N'Tel Aviv (Horario de verano de Israel, GMT+03:00)', CAST(3.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (46, N'Abu Dhabi (Hora de Arabia, GMT+04:00)', CAST(4.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (47, N'Moscú (Hora de Rusia, GMT+04:00)', CAST(4.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (48, N'Kabul (Hora de Afganistán, GMT+04:30)', CAST(4.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (49, N'Teherán (Horario de verano de Irán, GMT+04:30)', CAST(4.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (50, N'Bakú (Horario de verano de Bakú, GMT+05:00)', CAST(5.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (51, N'Ekaterimburgo (Hora de Asia Occidental, GMT+05:00)', CAST(5.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (52, N'Islamabad (Hora de Asia Occidental, GMT+05:00)', CAST(5.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (53, N'Colombo (Hora de Colombo, GMT+05:30)', CAST(5.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (54, N'Bombay (Hora de India, GMT+05:30)', CAST(5.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (55, N'Katmandú (Hora de Nepal, GMT+05:45)', CAST(5.45 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (56, N'Almaty (Hora de Asia Central, GMT+06:00)', CAST(6.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (57, N'Bangkok (Hora de Bangkok, GMT+07:00)', CAST(7.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (58, N'Pekín (Hora de China, GMT+08:00)', CAST(8.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (59, N'Kuala Lumpur (Hora de Malasia, GMT+08:00)', CAST(8.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (60, N'Perth (Hora de Australia Occidental, GMT+08:00)', CAST(8.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (61, N'Singapur (Hora de Singapur, GMT+08:00)', CAST(8.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (62, N'Taipei (Hora de Taipéi, GMT+08:00)', CAST(8.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (63, N'Seúl (Hora de Corea, GMT+09:00)', CAST(9.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (64, N'Tokio (Hora de Japón, GMT+09:00)', CAST(9.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (65, N'Adelaida (Hora estándar de Australia Central, GMT+09:30)', CAST(9.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (66, N'Darwin (Hora de Australia Central, GMT+09:30)', CAST(9.30 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (67, N'Brisbane (Hora de Australia Oriental, GMT+10:00)', CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (68, N'Guam (Hora del Pacífico Occidental, GMT+10:00)', CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (69, N'Hobart (Hora estándar de Tasmania, GMT+10:00)', CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (70, N'Sydney (Hora estándar de Australia Oriental, GMT+10:00)', CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (71, N'Yakutsk (Hora de Yakutsk, GMT+10:00)', CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (72, N'Islas Salomón (Hora del Pacífico Central, GMT+11:00)', CAST(11.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (73, N'Vladivostok (Hora de Vladivostok, GMT+11:00)', CAST(11.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (74, N'Fiji (Hora de Fiyi, GMT+12:00)', CAST(12.00 AS Decimal(4, 2)))
INSERT [dbo].[cmon_timezone] ([timezoneid], [title], [OffSet]) VALUES (75, N'Wellington (Hora estándar de Nueva Zelanda, GMT+12:00)', CAST(12.00 AS Decimal(4, 2)))
SET IDENTITY_INSERT [dbo].[cmon_timezone] OFF

Espero que les sea de utilidad