这么简单的SQL语句,为什么出错啊? SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE (Book_Discount BETWEEN 80 AND 100) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 加了个引号就代表字符了,当然会出错SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE Book_Discount BETWEEN 80 AND 100) 加了个引号就代表字符了,当然会出错SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE Book_Discount BETWEEN 80 AND 100 对象名 'T_BookInfo' 无效。 怎么回事? 加引号也能隐性转换的啊,楼主你还是检查下Book_Discount 的数据看看吧 SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE Book_Discount BETWEEN 80 AND 100 SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE (Book_Discount BETWEEN 80 AND 100)如果Book_Discount字符型就要加引号 SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE (Book_Discount BETWEEN 80 AND 100)数字型的就不要‘’ 那看你表名 是不是_BookInfo 这个! SELECT Book_ID, Book_DiscountFROM T_BookInfoWHERE (Book_Discount BETWEEN '80' AND '100')應該不會出錯,除非Book_Discount即不是字符型,也不是數值型,可能是其它類型,比如為日期型就會出錯. 取小于当前值的最大值的那条记录. 的sql 怎么写 关于空值的问题 基础问题,SQL中的存储过程的循环语句 请问SQL2005新增的with是怎么使用的? CREATE TABLE Z2(GHY INT REFERENCES Z1(GHY)) 求助SQL sql server2005 表空间问题 小问题。 我用SQL SERVER2000企业管理器备份数据库时,出现如下问题.希望得到您的指教! SQL server7触发器的问题,是否存在不触发的BUG?如何测试? 关于数据库模型 Access库导入到sqlserver2000中,表间关系与视图如何导入。。急,,在线等
SELECT Book_ID, Book_Discount
FROM T_BookInfo
WHERE Book_Discount BETWEEN 80 AND 100)
SELECT Book_ID, Book_Discount
FROM T_BookInfo
WHERE Book_Discount BETWEEN 80 AND 100
怎么回事?
FROM T_BookInfo
WHERE Book_Discount BETWEEN 80 AND 100
FROM T_BookInfo
WHERE (Book_Discount BETWEEN 80 AND 100)如果Book_Discount字符型就要加引号
FROM T_BookInfo
WHERE (Book_Discount BETWEEN 80 AND 100)
数字型的就不要‘’
FROM T_BookInfo
WHERE (Book_Discount BETWEEN '80' AND '100')應該不會出錯,除非Book_Discount即不是字符型,也不是數值型,可能是其它類型,比如為日期型就會出錯.