算法为什么是错误的
"110505195611","杨林 ","计算机 ","男",1980-02-10 00:00:00,50,"""110505195612","朱南辉 ","计算机应用","男",1981-12-11 00:00:00,50,"三好学生"
"110505195613","方小花 ","计算机应用","女",1980-05-12 00:00:00,52,""
"110505195614","李美丽 ","计算机应用","女",1982-03-06 00:00:00,54,"提前休完数据库"
"110505195615","刘星宇 ","计算机应用","女",1981-12-14 00:00:00,50,""
"110505195616","王丹凤 ","计算机应用","女",1981-04-15 00:00:00,50,"三好学生"
"110505195617","郝娟 ","计算机应用","女",1980-12-20 00:00:00,52,"已提前修完一门"
"110505195618","侯艳珍 ","计算机应用","女",1981-12-04 00:00:00,48,"有一门课程不及格"
"110505195619","司艳丽 ","计算机信息","女",1982-09-18 00:00:00,42,"已提前修完一门"
"110505195620","周国磊 ","计算机信息","男",1980-12-12 00:00:00,42,""
"110505195621","刘发党 ","计算机信息","男",1981-11-20 00:00:00,42,""
"110505195622","李鹏 ","计算机信息","男",1981-11-20 00:00:00,42,"有一门课不及格"
"110505195623","牛文超 ","计算机信息","男",1981-07-22 00:00:00,42,""
"110505195624","郝新刚 ","计算机信息","男",1982-12-09 00:00:00,44,"已提前修完一门"
"110505195625","顾金牛 ","计算机信息","男",1980-01-24 00:00:00,42,""
"110505195626","张成云 ","计算机网络","男",1981-09-16 00:00:00,50,""
"110505195627","刘俊芳 ","计算机网络","女",1981-06-26 00:00:00,50,""
"110505195628","王国栋 ","计算机网络","男",1982-04-11 00:00:00,50,""
"110505195629","史维华 ","应用电子 ","男",1981-08-28 00:00:00,50,"转专业学习"
"110505195630","史周平 ","计算机软件","男",1982-10-05 00:00:00,50,"三好学生"
这是例子,在学籍管理的学生表中,我用这句话为什么不对,
use 学籍管理
select *
from 学生
where 学号 between "110505195612"and "110505195619"
go
消息上说服务器: 消息 207，级别 16，状态 3，行 1
列名 '110505195612' 无效。
服务器: 消息 207，级别 16，状态 1，行 1
列名 '110505195619' 无效。
我想知道为什么
谢谢了[em02] 学号是什么类型的？
回复 1# 的帖子
用这个看看use 学籍管理
select * from 学生 where 学号 in( '110505195612', '110505195619')
go 双引号换成单引号
页:
[1]