Ⅰ 用sql語句編程給出創建Student(sno,sname,ssex,sbirthday,sclass)表的完整SQL語句，要求將sno定義為主鍵，
create table student( sno c(8) prim key, sname c(8), ssex c(2) check ssex='F' or ssex='M' ; default 'F' , sbirthday d , sclass c(10) )
不過你要注意，當用這條語句的時候，應該先建立資料庫，把student 作為資料庫表，只有資料庫表才可以定義主鍵
Ⅱ 為Student表中的Sno屬性升序建立唯一索引,寫出相應的SQL語句
create
unique
index
student_sno_idx
on
student(sno);
建立唯一索引的列上不能有重復的值,即該列要滿足not
null和unique約束
Ⅲ 第一步，使用SQL語句建立一個表avg_grade，兩個欄位sno、avggrade，分別為字元串類型和實數類型。
CREATE TABLE AVG_GRADE(SNO VARCHAR(50),AVGGRADE DECIMAL(10,4))
GO
INSERT INTO AVG_GRADE SELECT SNO,AVG(AVGGRADE) FROM SC GROUP BY SNO
GO
CREATE TRIGGER 觸發器名 ON SC
FOR INSERT,UPDATE,DELETE
AS
BEGIN
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
DELETE FROM AVG_GRADE WHERE SNO = (SELECT SNO FROM INSERTED)
INSERT INTO AVG_GRADE SELECT SNO,AVG(AVGGRADE) FROM SC WHERE SNO = (SELECT SNO FROM INSERTED) GROUP BY SNO
END
IF EXISTS(SELECT * FROM DELETED) AND NOT EXISTS(SELECT * FROM INSERTED)
BEGIN
DELETE FROM AVG_GRADE WHERE SNO = (SELECT SNO FROM DELETED)
INSERT INTO AVG_GRADE SELECT SNO,AVG(AVGGRADE) FROM SC WHERE SNO = (SELECT SNO FROM DELETED) GROUP BY SNO
END
END
GO
Ⅳ 實驗中的SQL部分 學生表:Student(Sno,Sname,Ssex,Sage,Sdept) 課程
1.SELECT * FROM Student;
2.SELECT Sno,Sname,Sage FROM Student WHERE Sdept='信息系';
3.SELECT Sno FROM SC WHERE Grade<60;
5.SELECT * FROM FROM Student ORDER BY Sage ASC;
6.SELECT S.Sno,S.Sname FROM Student S,Course C,SC WHERE S.Sno=SC.Sno AND C.Cno=SC.Cno AND C.Cname=課程名;
7.SELECT Sname,Sage,Sdept FROM Student WHERE Sage BETWEEN 20 AND 23;
8.SELECT S.Sno,S.Sname FROM Student S,Course C,SC WHERE S.Sno=SC.Sno AND C.Cno=SC.Cno AND C.Cname IN ('計算機導論','高等數學');
9.SELECT * FROM Student WHERE Sname LIKE '張%';
11.SELECT COUNT(SC.Sno) FROM Course C,SC WHERE C.Cno=SC.Cno AND Cname=課程名;
12.SELECT S.Sno,S.Sname,SC.Grade FROM Student S,SC WHERE S.Sno=SC.Sno AND SC.Cno='C05' ORDER BY SC.Grade DESC;
13.SELECT Cno,Cname,AVG(Grade),COUNT(Sno) FROM Course C,SC WHERE C.Cno=SC.Cno AND Grade IS NOT NULL GROUP BY Cno,Cname;
15.SELECT Sno,Sname,Sdept FROM Student S,SC WHERE S.Sno=SC.Sno GROUP BY Sno,Sname,Sdept HAVING AVG(Grade)>75;
17.SELECT Sno FROM (SELECT TOP 1 S.Sno,AVG(Grade) FROM Student S,SC WHERE S.Sno=SC.Sno GROUP BY S.Sno ORDER BY AVG(Grade)),
20 SELECT TOP 3 Sno,Sname,Sdept FROM Student S,Course C,SC WHERE S.Sno=SC.Sno AND C.Cno=SC.Cno AND C.Cname='高等數學' ORDER BY SC.Grade;
Ⅳ 用SQL語句在SQL Server2000下實現如下功能。所用資料庫表結構如下： student（學生表）：（sno，學號，9字
1.CREATE TABLE SC
(sno varchar(9)，
cno varchar(5)，
grade int )
2.alter table sc add constraint fk_sd_student
foreign key (sno)
references student (sno) on delete cascade
3.select sdept , sname from student where sdept = '計算機系' and ssex = '男'
4.select sno from sc where cno = '200515120'
5.delete from sc where sno in (select sno from student where sdept = '計算機系' and ssex = '男')
6.grant select , update on student to u2
7.select sname from student where sno in
(select sno , count(sno) from sc group by sno
having count(sno) = '總選修課數' )
Ⅵ 寫出實現下列操作的SQL語句 （1）建立一個「學生」表Student,它由學號（sno）,
--創建表
createtablestudent
(snochar(8)primarykey,
snamechar(10),
genderchar(2),
departmentchar(20),
ageint)
--修改學號長度
(10)notnull;
--刪除表
droptablestudent
Ⅶ 用SQL語句創建簡單數據表 設某資料庫中有學生表（Students），包括學號sno，姓名snam
create table Students
(
Sno varchar(10) primary key,
Sanme varchar(10) not null,
SD datetime
)
Ⅷ sql中資料庫主外鍵關聯問題
你先把student
和
teacher
表建立起來，並且分別把cno和tno設為primarykey.
然後在建立
課程
和
選課
兩個表。建立課程表的時候把Tno欄位對應上教師表的主鍵，也就是課程表的Tno欄位為教師表主鍵的外鍵欄位。
同理：成績表的Sno欄位對應學生表的主鍵，這樣兩個駐外見關系就建立起來了。
Ⅸ 怎樣用SQL命令為表student 以 sno 欄位為索引關鍵字建立主索引
create unique index student_index on student(sno)
Ⅹ 為Student表中的Sno屬性升序建立唯一索引，寫出相應的SQL語句
create unique index student_sno_idx on student(sno);
建立唯一索引的列上不能有重復的值，即該列要滿足not null和unique約束