Kizspy.me
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)
Beh
Student StudentLastName StudentFirstName StudentSex Studentbirthday StudentEmal
2
M
2003-07-21
StudentPhone StudentAddress
0923456789
Department StudentScholarsh
700
Em
Du
16
Mac
26
Tao
32
LUU
35
-
38
Vinh
Cha
Tan
Tuan
10
41
Van
Lan
11
Due
Rang
12
* * v * 8 * ƒ Z * j r
2002-12-25
em
[email protected] 0066700012
15 Tan Phu Da Nang
800
M
2000-02-14
hung
[email protected]
0000012345
Brunch. Tinh Duong
2
350
M
2002-12-30
Phuc
2000-12-12
son
[email protected]
photo
0067890123
So Phan Vitong Ho Chí Minh 2
350
bạn. 0044455566
2
300
2001-10-05
[email protected] 0000011223
100 Le Duan, Ha Phong
2
750
2002-01-11
an
[email protected]
Deep
2000-05-25
0033344556
ông chaulongho con 00666775 000 Trung Chinh, Ho Chi Minh
2
450
2
600
M
2001-12-29
ket
[email protected]
2003-06-17
lan
[email protected]
0988809001
0099900123
888 Le Lo Da Nang
350
750
2002-10-30
tàng đạo (Dexan cho con
2003-06-28
yen
[email protected]
0063567890 1900 Torin Thanh Ho Chi Minh 2
6011238572100 Trong Dr, Har
600
2002-09-19
ket
[email protected]
0977789013 2700 Pham Van Dong Ha Phong 2
Zoom
+ 93%
Picture 10.1
Close
