Week 6 Data Base IET, Sql Server

Week 6 Data Base IET

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

create table student(
    studentRegNo int,
    studentName text,
    studentAdd text,
    studentMarks int,
    
    );
    
    insert into student values ( 1001, 'Kamran', 'NSR', 500)
    insert into student values ( 1002, 'Usman', 'SWB', 750)
    insert into student values ( 1003, 'Sunny', 'PSH', 450)
    insert into student values ( 1004, 'Asad', 'MDN', 550)
    insert into student values ( 1005, 'Atif', 'SWT', 800)
    insert into student values ( 1006, 'Junaid', 'LHR', 800)
    insert into student values ( 1007, 'Waqar', 'MDN', 440)
    insert into student values ( 1008, 'Aamir', 'SWB', 745)
    insert into student values ( 1009, 'Naseer', 'NSR', 590)
    insert into student values ( 1010, 'Naveed', 'SWB', 670)
    select *from student;
    
            select studentRegNo as StudenIdentification from student;
            select top 3 * from student;
            select top 35 percent *from student;
            select * from student where studentMarks between 450  and 700 ;

View schema
Execution time: 0,02 sec, rows selected: 33, rows affected: 10, absolute service time: 0,19 sec, absolute service time: 0,19 sec

	sql server version
1	Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)

	studentRegNo	studentName	studentAdd	studentMarks
1	1001	Kamran	NSR	500
2	1002	Usman	SWB	750
3	1003	Sunny	PSH	450
4	1004	Asad	MDN	550
5	1005	Atif	SWT	800
6	1006	Junaid	LHR	800
7	1007	Waqar	MDN	440
8	1008	Aamir	SWB	745
9	1009	Naseer	NSR	590
10	1010	Naveed	SWB	670

	StudenIdentification
1	1001
2	1002
3	1003
4	1004
5	1005
6	1006
7	1007
8	1008
9	1009
10	1010

	studentRegNo	studentName	studentAdd	studentMarks
1	1001	Kamran	NSR	500
2	1002	Usman	SWB	750
3	1003	Sunny	PSH	450

	studentRegNo	studentName	studentAdd	studentMarks
1	1001	Kamran	NSR	500
2	1002	Usman	SWB	750
3	1003	Sunny	PSH	450
4	1004	Asad	MDN	550

	studentRegNo	studentName	studentAdd	studentMarks
1	1001	Kamran	NSR	500
2	1003	Sunny	PSH	450
3	1004	Asad	MDN	550
4	1009	Naseer	NSR	590
5	1010	Naveed	SWB	670