Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
QLSV
create table hs ( mssv int, ho varchar(10), dem varchar(10), ten varchar(10), ngaysinh date ); create table chuong_trinh_dao_tao ( ma_hp varchar(10), ten_hp varchar(20), ky_hoc varchar(10), tin_chi_hoc real, ghi_chu varchar(100), vien_khoa varchar(100) ); create table mon_hoc ( ma_mon varchar(10), ten_mon varchar(50), tin_chi_hoc_phan real, tin_chi_hoc_phi real ); create table kqht ( mssv int, ma_mon varchar(10), diem_so int, diem_chu varchar(2) ); create table tkh ( thoi_gian date, tuan_hoc int, phong_hoc varchar(10), ma_lop varchar(10), loai_lop varchar(10), nhom varchar(20), ma_hp varchar(10), ten_lop varchar(20), ghi_chu varchar(100), giang_vien varchar(20) ); create table lich_thi ( ma_lop_thi varchar(10), ma_lop_hoc varchar(10), ma_hp varchar(10), ten_hp varchar(50), dot varchar(2), tuan int, thu varchar(10), ngay date, kip int, phong varchar(10) ) create table bang_diem_ca_nhan ( hoc_ky varchar(10), ma_hp varchar(10), ten_hp varchar(50), tin_chi real, lop_hoc varchar(10), diem_qua_trinh real, diem_thi real, diem_so real, diem_chu varchar(2) ) create table bang_diem_hoc_phan ( ma_vien varchar(10), ten_sv varchar(50), ma_hp varchar(10), ten_hp varchar(50), diem_chu varchar(2), diem_so real ) insert into hs values(20185353, 'Pham', 'Van', 'Hieu', '2000-9-7'); select * from hs; drop table hs;
run
|
edit
|
history
|
help
0
/Users/svetlanakanevskaa/Downloads/ACDB_LIGHT_MS.sql
SS mysqlsvr 2014 practice
viernes_ alumnos
a
base de datos dbfloreria
MSSQL NVARCHAR to INT conversions
Negociosj
SQL_RankingFunctions
extract part of a string
group for team members and winners in sql-server