各位大师耽误你们一点时间帮初级菜鸟一下吧!比如我要在数据库中创建一个表:
'创建“填空题”数据表,每题只能一个空
strSQL = "Create Table 填空题 (" _
& "编号 int identity primary key," _
& "章节 int not null," _
& "图片 varchar(50)," _
& "题干 varchar(200) not null," _
& "难度 tinyint not null," _
& "答案1 varchar(50) not null," _
& "答案2 varchar(50))"
objCn.Execute strSQL
'创建“章节”数据表
strSQL = "Create Table 章节 (" _
& "编号 int identity primary key," _
& "名称 varchar(50) not null)"
objCn.Execute strSQL
objCn.Close
Set objCn = Nothing
MsgBox "数据库已成功创建!"那么这些“&”和引号 的具体作用是什么呢?在SQL查询分析器中输入的SQL语言好像不用这些连接符号的吧?谢谢各位帮忙了
'创建“填空题”数据表,每题只能一个空
strSQL = "Create Table 填空题 (" _
& "编号 int identity primary key," _
& "章节 int not null," _
& "图片 varchar(50)," _
& "题干 varchar(200) not null," _
& "难度 tinyint not null," _
& "答案1 varchar(50) not null," _
& "答案2 varchar(50))"
objCn.Execute strSQL
'创建“章节”数据表
strSQL = "Create Table 章节 (" _
& "编号 int identity primary key," _
& "名称 varchar(50) not null)"
objCn.Execute strSQL
objCn.Close
Set objCn = Nothing
MsgBox "数据库已成功创建!"那么这些“&”和引号 的具体作用是什么呢?在SQL查询分析器中输入的SQL语言好像不用这些连接符号的吧?谢谢各位帮忙了
& "的作用是链接字符串用的 你也可以不用他 只能这样写
strSQL = "Create Table 填空题 (" 编号 int identity primary key," 章节 int not null图片 varchar(50,题干 varchar(200) not null,难度 tinyint not null,答案1 varchar(50) not null,答案2 varchar(50))"
strsql = "SELECT * FROM 轿运车 WHERE 型号 LIKE '"_
& a.c1 & "' AND 出厂年份 LIKE '"_
& b.c2 & "'"