第 2 讲 Transact-SQL 语言
-
Upload
alexandra-buck -
Category
Documents
-
view
164 -
download
0
description
Transcript of 第 2 讲 Transact-SQL 语言
-
2 Transact-SQL
-
Transact-SQL 1 ?Structured Query Language[]
-
Transact-SQL 1DDLDDL:CREAT TABLE/**/ALTER TABLE/**/DROP TABLE/**/2DMLT-SQLDMLSELECT/**/DELETE/**/INSERT /**/ UPDATE/**/3DCLGRANT/**/ REMOVE/**/
-
SELECTSELECTSELECT FROM WHEAR Student00000001StuName01
-
1*2DISTINCT3TOP n [PERCENT]6
-
41 23AS
-
5 SQL Server 001 001
-
6WHERE001Linux7SELECT
-
8ORDER BYORDER BY
9INNOT IN001004013OR IN
-
1LIKENOT LIKE%0_[][m-p][^][^m-p][^mnop]D%_[^a][[][%]DLIKENOT LIKE
-
2IS NULL
-
3BETWEENANDNOT BETWEENAND3040BETWEENAND[]WHERE WillNum BETWEEN 30 AND 403040NOT BETWEENANDWHERE
-
4UNION12[]12
-
5COMPUTE[] WHERE12COMPUTE[]AVG()MAX()MIN()SUM()SELECTPAGE 392.10[]12
-
6COMPUTEBY[]ORDER BYCOUNT
-
COMPUTEBY
-
1GROUP BY[]1GROUP BYWHERE2GROUP BYSELECTSELECTGROUP BY
-
2HAVING[]HAVINGGROUP BYWHEREHAVINGWHERE[]HAVINGGROUP BY3001
-
3STEP 1STEP 2
-
SQL SELECT
-
2 USE XkGOSELECT *FROM Department, ClassGO54318523
-
: [] 1DepatNoWHERENN-123
-
01[] WHERE[]SELECT.
-
1
-
2[]2.5
-
1234
-
EXISTS[]EXISTS[]TRUEFALSE
-
NOT EXISTS 001select stuno,stunamefrom studentwhere not exists(select * from stucouwhere stuno=student.stuno andcouno='001')
-
EXISTS