Kizspy.me
8 of 8
Paper No: 1
result
1
11
Picture 9.1
Question 10:
[0.5 mark] Create a inline table-valued function named fn_students to return the list of
students with scholarships >0 from the department with the given departmentID.
Where @departmentID int is an input parameter, this function will return table containing
students' information with scholarships >0 for the department.
For example, when we execute the function by using the following statements
select * from fn_students(2)
Student StudentLastName StudentFirstName StudentSex Studentbirthday StudentEmal
StudentPhone StudentAddress
Department StudentScholarship
S
Hong
fm
3
Du
M
16
Mac
Son
M
2003-07-21
2002-12-25
2000-02-14
2002-12.30
45 Phong Hoa Tran Ha
2
700
em
[email protected] 0956789012
hung
[email protected] 0000012345
son
[email protected]
15 Tan Phu Da Nang
800
350
26
Tao
Phuc
2000-12-12
6
32
LI
2001-10-05
[email protected]
0067890123
0044455566
0000011223 100 Le Duan, Ha Phong
S6 Phan Van Dong Ho Chí Minh 2
Đạt Ton Duc Trung Hai trong
350
300
750
35
2002-01-11
an thanh của con 0003336
38
Chav
Do
2000-05-25
°
Tuan
2001-12-29
10 41
Van
2003-06-17
ng cho rich con 006776
ket
[email protected] 09899001
lan
[email protected] 0000900123
333 Tran Quoc Toan Hùng
Trong
888 Le Lo Da Nang
450
HỌC M
600
350
ĐẠI HUỆ Tran Ha trong
750
Dao
Rang
2002-10-30
rang
[email protected] 0955567890
1900 To Hơn Thanh, Ho Chi Minh 2
12 53
Tan
Yen
2003-06-28
yen
[email protected]
59
Bao
2002-09-19
ket
[email protected]
0911123457
0977709013
2000 trong tình. Hạng
2
450
2000 Phim Van Dong Ha trong 2
Zoom
+ 93%
Close
