2016第章 数据查询一.pptVIP

第二章-2 数据查询(一)　 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 回顾 代码改错 1、INSERT INTO Students (SName,SAddress,SGrade,SEmail,SSEX) VALUES (张青裁,上海松江,6,ZQC@S) 2、INSERT INTO Students (SCode, SName,SAddress,SGrade,SEmail,SSEX) VALUES (100,张青裁,上海松江,6,ZQC@S,0) 3、INSERT INTO StudentsInfo (姓名, 地址, 电子邮件) SELECT SName,SAddress,SEmail FROM Students 4、Update Students Set SName = ‘胡斐’ Set SSex = ‘1‘ Where SName = ‘胡非 1、INSERT INTO Studen