Y2S1-Database_Design/SQL/individual_inserts/7 - Category.Table.sql

<EFBFBD><EFBFBD>USE [MediaLibrary]
GO
SET IDENTITY_INSERT [dbo].[Category] ON 

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (1, N'Comedy')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (2, N'Education')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (3, N'Entertainment')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (4, N'Film')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (5, N'Animation')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (6, N'Show')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (7, N'Gaming')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (8, N'News')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (9, N'Vlogs/Blogs')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (10, N'Technology')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (11, N'Sport')
SET IDENTITY_INSERT [dbo].[Category] OFF