insert into dbo.T_student(Stud_id,Stud_name,Stud_sex,Birth_date,Entry_date,Mobile,Birth_place) values('200901001','张学友','男',1980-10-4,2009-09-1,'15012345678','湖南长沙')
--插入数据要记得数据类型匹配
select * from dbo.T_student where Birth_place='湖南长沙' --查找
SELECT T_score.Score
FROM T_student INNER JOIN
T_score ON T_student.Stud_id = T_score.Stud_id where Stud_name='张学友'
select avg(Score)as '平均成绩' from dbo.T_score,dbo.T_course where dbo.T_score.Course_id=dbo.T_course.Course_id and Course_name='数据库应用' --查找
create view query -- 创建视图
AS
select Stud_name,Mobile,Birth_place
from T_student
create Procedure P_test -- 创建存储过程
@Course_name varchar(100),
@Max_c_name decimal(5,2) output
as
select Max_c_name=Max(Score)from T_score
where T_score.Course_id=T_course.Course_id