数据查询之SELECT语句综述.pptVIP

欢迎进入刘天天讲堂！ 创建表 % Dim cnn, sSQL Set cnn = Server.CreateObject(ADODB.Connection) cnn.ConnectionString = PROVIDER=SQLOLEDB;DATA SOURCE=(local); _ “UID=sa;PWD=sa;DATABASE=xs cnn.Open sSQL = “CREATE TABLE xsda( 学号 varchar(6), 姓名 varchar(8) ) 执行CREATE TABLE命令 cnn.Execute sSQL, , adCmdText cnn.Close Set cnn = Nothing % （课外阅读：） 检索记录 % Dim cnn, rst, sSQL, i Set cnn = Server.CreateObject(ADODB.Connection) Set rst = Server.CreateObject(ADODB.Recordset) cnn.ConnectionString = PROVIDER=SQLOLEDB;DATA SOURCE=(local); _ UID=sa;PWD=sa;DATABASE=Northwind cnn.Open sSQL = SELECT EmployeeID, LastName, Firs