chuc moi ng vui ve!

/* Phạm Thị Ly cntt k1c */
/* bai4-cau2 */

alter table detai
add soluong float


declare contro cursor
for select msdt,tendt,soluong from detai
open contro
declare @soluong float
declare @msdt char(6)
declare @tendt nchar(30)
fetch next from contro into @msdt,@tendt,@soluong
while @@fetch_status=0
begin
select @soluong=count(mssv)
from sv_detai,detai
where sv_detai.msdt=detai.msdt
and detai.msdt=@msdt

print N'mã số đề tài:' +@msdt +' ' + N'tên đề tài:' +@tendt + ' '+ N'số lượng:' + convert(varchar(5),@soluong)


fetch next from contro into @msdt,@tendt,@soluong
end
close contro
deallocate contro

very happy hi2 con ai co phat kien moi moi dong gop nhe!!! thanhks Ly nhieu

bài 4- câu1:
alter table sv_detai
add diem float,
xloai varchar(10)
declare contro cursor
for select msdt from sv_detai
open contro

declare @msdt char(6)
fetch next from contro into @msdt
while @@fetch_status=0
begin
update sv_detai
set sv_detai.diem=(select (gv_hddt.diem+gv_pbdt.diem+sum(gv_uvdt.diem))/5
from gv_hddt,gv_pbdt,gv_uvdt,sv_detai
where(sv_detai.msdt=gv_hddt.msdt)
and(sv_detai.msdt=gv_pbdt.msdt)
and(sv_detai.msdt=gv_uvdt.msdt)
and(sv_detai.msdt=@msdt)
group by sv_detai.msdt,gv_hddt.diem,gv_pbdt.diem)


where( sv_detai.msdt=@msdt)

update sv_detai
set sv_detai.xloai=N'giỏi'
where(sv_detai.msdt=@msdt)and (sv_detai.diem>=9)


update sv_detai
set sv_detai.xloai=N'khá'
where(sv_detai.msdt=@msdt)and(sv_detai.diem>=7)and(sv_detai.diem<9)


update sv_detai
set sv_detai.xloai=N'trung binh'
where(sv_detai.msdt=@msdt)and(sv_detai.diem>=5)and(sv_detai.diem<7)


update sv_detai
set sv_detai.xloai=N'không đạt'
where(sv_detai.msdt=@msdt)and (sv_detai.diem<5)

fetch next from contro into @msdt
end
close contro
deallocate contro
go
select*from sv_detai
--cố lên các bạn!!!

ca bai cua to va cua son moi nguoi cho cau lenh update vao.voi bai cua son thi nho update ca diem nua do.con bai to ko hieu de bai rut cuc la the nao.ma chay theo cach minh hieu cung chua ra chinh xac nua.po tay!