问答题
将字符串’I am a student’以大写字母显示。
SELECT UPPER(‘I am a student’)
问答题 create procedure xxk5 ( @a char(8),@b varchar(10),@c numeric(5,2) ) as begin insert into score values(@a,@b,@c) end
问答题 create procedure xxk3 as begin select学号,avg(成绩) as 平均成绩 from score group by学号 end
问答题 create procedure xxk1 as begin select * from students x,score y where x.学号=y.学号 end
