Skip to content

Instantly share code, notes, and snippets.

@jlamch
Created February 3, 2019 15:59
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save jlamch/ca41de1791d1cc2f5eb7c0c4af53507a to your computer and use it in GitHub Desktop.
/* ==Scripting Parameters==
Source Server Version : SQL Server 2016 (13.0.4001)
Source Database Engine Edition : Microsoft SQL Server Express Edition
Source Database Engine Type : Standalone SQL Server
Target Server Version : SQL Server 2017
Target Database Engine Edition : Microsoft SQL Server Standard Edition
Target Database Engine Type : Standalone SQL Server
*/
USE [Experiments]
GO
/****** Object: Table [dbo].[Girls] Script Date: 2/3/2019 16:58:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Girls](
[GirlsID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](255) NULL,
[Id] [int] NULL,
[TypeId] [int] NULL,
PRIMARY KEY CLUSTERED
(
[GirlsID] 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
/****** Object: Table [dbo].[GirlType] Script Date: 2/3/2019 16:58:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GirlType](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nchar](25) NULL,
[TypeIdentity] [int] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Girls] ON
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (1, N'Tana', 1, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (2, N'Jessica', 2, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (3, N'Aileen', 3, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (4, N'Camilla', 4, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (5, N'Regan', 5, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (6, N'Hillary', 6, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (7, N'Quail', 7, 4)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (8, N'Clementine', 8, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (9, N'Jeanette', 9, 4)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (10, N'Megan', 10, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (11, N'Halla', 11, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (12, N'Idona', 12, 1)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (13, N'Kirsten', 13, 4)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (14, N'Casey', 14, 1)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (15, N'Imelda', 15, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (16, N'Jasmine', 16, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (17, N'Leah', 17, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (18, N'Chelsea', 18, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (19, N'Quail', 19, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (20, N'Teagan', 20, 2)
GO
SET IDENTITY_INSERT [dbo].[Girls] OFF
GO
SET IDENTITY_INSERT [dbo].[GirlType] ON
GO
INSERT [dbo].[GirlType] ([Id], [Name], [TypeIdentity]) VALUES (2, N'Engineer ', 1)
GO
INSERT [dbo].[GirlType] ([Id], [Name], [TypeIdentity]) VALUES (3, N'General ', 3)
GO
INSERT [dbo].[GirlType] ([Id], [Name], [TypeIdentity]) VALUES (4, N'Queen ', 4)
GO
SET IDENTITY_INSERT [dbo].[GirlType] OFF
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment