看不下去了给表s**e的id列添加备注“序号”exec sp_addextendedproperty 'ms_description','序号','user',dbo,'table','s**e','column',id以及查询s**e表所有列的备注selecta.name as table_name,b.name as column_name,c.value as column_descriptionfrom sys.tables ainner join sys.columns b on b.object_id = a.object_idleft join sys.extended_properties c on c.major_id = b.object_id and c.minor_id = b.column_idwhere a.name = 's**e' 20210311
select bbb.班级名称, aaa.最高分 from select 班级号, max(成绩)as 最高分 select 班级号, 成绩 from 成绩表 a left join 学生表 b on a.学号=b.学号 aa group by 班级号 aaa left join 班级表 bbb on aaa.班级号=bbb.班级号 create table t(学号 varchar(10),班级...