-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathscript.sql
More file actions
14 lines (13 loc) · 713 Bytes
/
script.sql
File metadata and controls
14 lines (13 loc) · 713 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
--Creating 'SubjectDetails' table
CREATE TABLE [dbo].[SubjectDetails](
[SubjectId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[SubjectName] [nvarchar](100) NULL)
--Inserting records to 'SubjectDetails' table
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('Asp.net')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('C#')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('Vb.net')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('JavaScript')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('jQuery')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('HTML')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('CSS')
INSERT INTO [SubjectDetails] ([SubjectName]) VALUES ('SQL Server')