-
Notifications
You must be signed in to change notification settings - Fork 0
/
QuestionList.sql
26 lines (26 loc) · 4.8 KB
/
QuestionList.sql
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
USE [QuizDB]
GO
SET IDENTITY_INSERT [dbo].[Questions] ON
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (1, N'What breed is this dog?', N'1.jpg', N'German Sheperd', N'Rottweiler', N'Siberian Husky', N'Dalmatian', 0)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (2, N'What breed is this dog?', N'2.jpg', N'Dobermann', N'Golden Retriever', N'German Sheperd', N'Pomeranian', 1)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (3, N'What breed is this dog?', N'3.jpg', N'Rottweiler', N'American Bully', N'Siberian Husky', N'Chihuahua', 2)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (4, N'What breed is this dog?', N'4.jpg', N'Golden Retriever', N'Poodle', N'Dobermann', N'Rottweiler', 3)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (5, N'What breed is this dog?', N'5.jpg', N'Dalmatian', N'Siberian Husky', N'Chihuahua', N'Pomeranian', 0)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (6, N'What breed is this dog?', N'6.jpg', N'German Sheperd', N'American Bully', N'Pomeranian', N'Poodle', 1)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (7, N'What breed is this dog?', N'7.jpg', N'American Bully', N'Poodle', N'Dobermann', N'Siberian Husky', 2)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (8, N'What breed is this dog?', N'8.jpg', N'Poodle', N'Golden Retriever', N'Chihuahua', N'Pomeranian', 3)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (9, N'What breed is this dog?', N'9.jpg', N'Chihuahua', N'Dobermann', N'German Sheperd', N'Poodle', 0)
GO
INSERT [dbo].[Questions] ([QnId], [QnInWords], [ImageName], [Option1], [Option2], [Option3], [Option4], [Answer]) VALUES (10, N'What breed is this dog?', N'10.jpg', N'Golden Retriever', N'Poodle', N'Dalmatian', N'Rottweiler', 1)
GO
SET IDENTITY_INSERT [dbo].[Questions] OFF
GO