SQL/CreateAndInsertData-API-Driven-Sample.SQL at main · ChrFrohn/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
CREATE TABLE [dbo].[Employees](
    [EmployeeId] [varchar](10) NOT NULL PRIMARY KEY,
    [Name_FirstName] [nvarchar](100) NULL,
    [Name_MiddleName] [nvarchar](100) NULL,
    [Name_LastName] [nvarchar](100) NULL,
    [Name_FullName] [nvarchar](300) NOT NULL,
    [Salutation] [tinyint] NOT NULL,
    [NickName] [varchar](50) NULL,
    [NationalityId] [varchar](50) NULL,
    [LanguageId] [varchar](50) NULL,
    [Email] [varchar](50) NULL,
    [Gender] [tinyint] NOT NULL,
    [BirthDate] [date] NULL,
    [RowNumber] [int] NOT NULL,
    [CreatedBy] [varchar](50) NOT NULL,
    [CreatedDateTime] [datetime2](7) NOT NULL,
    [ModifiedBy] [varchar](50) NULL,
    [ModifiedDateTime] [datetime2](7) NULL,
    [VersionStamp] [int] NOT NULL,
    [Active] [bit] NOT NULL,
    [Initials] [nvarchar](20) NULL,
    [LocationId] [varchar](10) NULL,
    [Location_Name] [varchar](50) NULL,
    [Office] [varchar](20) NULL,
    [ManagerId] [varchar](10) NULL,
    [Manager_Name] [nvarchar](300) NULL,
    [OrganizationId] [varchar](10) NULL,
    [OrganizationName] [varchar](50) NULL,
    [JobId] [varchar](10) NULL,
    [Job_Description] [varchar](50) NULL,
    [JobTypeId] [varchar](10) NULL,
    [JobType_Description] [varchar](50) NULL,
    [Title] [varchar](50) NULL,
    [ValidFrom] [date] NULL,
    [ValidTo] [date] NULL,
    [Released] [bit] NULL,
    [HiredDate] [date] NULL,
    [TerminatedDate] [date] NULL
);

INSERT INTO [dbo].[Employees]
(
    [EmployeeId],
    [Name_FirstName],
    [Name_MiddleName],
    [Name_LastName],
    [Name_FullName],
    [Salutation],
    [NickName],
    [NationalityId],
    [LanguageId],
    [Email],
    [Gender],
    [BirthDate],
    [RowNumber],
    [CreatedBy],
    [CreatedDateTime],
    [ModifiedBy],
    [ModifiedDateTime],
    [VersionStamp],
    [Active],
    [Initials],
    [LocationId],
    [Location_Name],
    [Office],
    [ManagerId],
    [Manager_Name],
    [OrganizationId],
    [OrganizationName],
    [JobId],
    [Job_Description],
    [JobTypeId],
    [JobType_Description],
    [Title],
    [ValidFrom],
    [ValidTo],
    [Released],
    [HiredDate],
    [TerminatedDate]
)
VALUES
('1', 'Darkwing', NULL, 'Duck', 'Darkwing Duck', 1, 'DW', 'US', 'EN', 'darkwing@duck.com', 1, '1987-09-06', 1, 'TestUser', GETDATE(), NULL, NULL, 1, 1, 'DD', '1', 'St. Canard', '1', '1', 'Launchpad McQuack', '1', 'Justice Ducks', '1', 'Superhero', '1', 'Hero', 'Mr.', '2024-05-14', NULL, 0, GETDATE(), NULL),
('2', 'Launchpad', NULL, 'McQuack', 'Launchpad McQuack', 1, 'LP', 'US', 'EN', 'launchpad@mcquack.com', 1, '1987-09-06', 2, 'TestUser', GETDATE(), NULL, NULL, 1, 1, 'LM', '1', 'St. Canard', '1', '1', 'Darkwing Duck', '1', 'Justice Ducks', '2', 'Sidekick', '2', 'Sidekick', 'Mr.', '2024-05-14', NULL, 0, GETDATE(), NULL),
('3', 'Gosalyn', NULL, 'Mallard', 'Gosalyn Mallard', 2, 'GM', 'US', 'EN', 'gosalyn@mallard.com', 2, '1987-09-06', 3, 'TestUser', GETDATE(), NULL, NULL, 1, 1, 'GM', '1', 'St. Canard', '1', '1', 'Darkwing Duck', '1', 'Justice Ducks', '3', 'Adopted Daughter', '3', 'Family', 'Miss', '2024-07-14', NULL, 0, GETDATE(), NULL),
('4', 'Honker', NULL, 'Muddlefoot', 'Honker Muddlefoot', 1, 'HM', 'US', 'EN', 'honker@muddlefoot.com', 1, '1987-09-06', 4, 'TestUser', GETDATE(), NULL, NULL, 1, 1, 'HM', '1', 'St. Canard', '1', '1', 'Darkwing Duck', '1', 'Justice Ducks', '4', 'Friend', '4', 'Friend', 'Mr.', '2024-07-01', NULL, 0, GETDATE(), NULL),
('5', 'Bushroot', NULL, 'Reginald', 'Bushroot Reginald', 1, 'BR', 'US', 'EN', 'bushroot@reginald.com', 1, '1987-09-06', 5, 'TestUser', GETDATE(), NULL, NULL, 1, 1, 'BR', '1', 'St. Canard', '1', '1', 'Darkwing Duck', '1', 'Fearsome Five', '5', 'Villain', '5', 'Villain', 'Mr.', '2024-07-01', NULL, 0, GETDATE(), NULL),
('6', 'Megavolt', NULL, 'Elmo', 'Megavolt Elmo', 1, 'ME', 'US', 'EN', 'megavolt@elmo.com', 1, '1987-09-06', 6, 'TestUser', GETDATE(), NULL, NULL, 1, 1, 'ME', '1', 'St. Canard', '1', '1', 'Darkwing Duck', '1', 'Fearsome Five', '6', 'Villain', '6', 'Villain', 'Mr.', '2024-07-01', NULL, 0, GETDATE(), NULL);