Y2S1-Database_Design/SQL/individual_inserts/9 - AudioGenre.Table.sql
2020-06-07 22:29:59 +01:00

15 lines
1.5 KiB
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

USE [MediaLibrary]
GO
SET IDENTITY_INSERT [dbo].[AudioGenre] ON
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (1, N'Blues')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (2, N'Country')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (3, N'Electronic')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (4, N'Folk')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (5, N'Hip Hop')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (6, N'Jazz')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (7, N'Pop')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (8, N'R%B')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (9, N'Rock')
SET IDENTITY_INSERT [dbo].[AudioGenre] OFF