1、第四章 查詢和修改數(shù)據(jù),Select 過濾數(shù)據(jù) 格式化結(jié)果集 Inserting Data Deleting Data Updating Data,查詢和修改數(shù)據(jù),內(nèi)容簡介,Select 過濾數(shù)據(jù) 格式化結(jié)果集 Inserting Data Deleting Data Updating Data,查詢和修改數(shù)據(jù),SELECT ALL | DISTINCT FROM ,n WHERE ,Partial Syntax,1 SELECT Statement,Select List WHERE FROM,查詢和修改數(shù)據(jù),1.1 指定列,USE northwind SELECT employeeid,

2、lastname, firstname, title FROM employees GO,查詢和修改數(shù)據(jù),1.2 WHERE 過濾行,查詢和修改數(shù)據(jù),修改列名,1）SELECT au_fname, au_lname, city, state， phone AS Telephone FROM authors -推薦使用 2）SELECT au_fname, au_lname, city, state， Telephone= phone FROM authors 3）SELECT au_fname, au_lname, city, state， phone Telephone FROM autho

3、rs,查詢和修改數(shù)據(jù),更改表名,1）SELECT a.* from authors as a 2）SELECT a.* from authors a 3）select b.* from (select * from authors) as b,查詢和修改數(shù)據(jù),Insert,單行數(shù)據(jù) INSERT VALUES 多行數(shù)據(jù) INSERTSELECT SELECT INTO 插入部分數(shù)據(jù) 使用默認插入數(shù)據(jù),查詢和修改數(shù)據(jù),插入單行數(shù)據(jù),語法 INSERT INTO 表名 列名序列 VALUES (值序列） 例子,查詢和修改數(shù)據(jù),DELETE,語法 DELETE FROM 表名 WHERE 刪除條件 例子,USE northwindDELETE orders WHERE DATEDIFF(MONTH, shippeddate, GETDATE() = 6 GO,查詢和修改數(shù)據(jù),USE northwind UPDATE products SET unitprice = (unitprice * 1.1) GO,Update,語法 UPDATE 表名 SET 列名=常量值 | 表達式 WHERE 更新條件 例子,查詢和修改數(shù)據(jù),回顧,Sele