sybase数据库中索引导致sql语句执行不成功
SELECT DISTINCT A.CASEPROP AS PROP,'旧存' AS AJLX,0 AS AJLXXH,A.CASE_PROP AS PROPNO
,M1=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2008.12.26 00:00:00' AND (SHUTDAY IS NULL OR
SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2008.12.26 00:00:00') )) ,
M2=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP
AND (PERMITDAY <'2009.01.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.01.26 00:00:00') )) ,
M3=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP
AND (PERMITDAY <'2009.02.26 00:00:00' AND (SHUTDAY IS NULL
OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.02.26 00:00:00') )) ,
M4=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.03.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.03.26 00:00:00') )) ,
M5=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.04.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.04.26 00:00:00') )) ,
M6=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.05.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.05.26 00:00:00') )) ,
M7=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.06.26 00:00:00' AND (SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.06.26 00:00:00') )) ,M8=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND (PERMITDAY <'2009.07.26 00:00:00' AND (SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.07.26 00:00:00') )) ,M9=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASEPROP AND (PERMITDAY <'2009.08.26 00:00:00' AND (SHUTDAY IS NULL OR
SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.08.26 00:00:00') )) ,M10=( SELECT COUNT(*) from CASES WHERE CASEPROP=A.CASE
相关文档：
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--每页显示记录条数
@currentpage int output,--第几页
@orderid nvarchar(50),--主键排序
@sort int,--排序方式，1表示升序，0表示降序排列
......
1.利用下面的脚本创建BOOK，READER 和 BORROW 表，并完成后面的联系。
CREATE TABLE BOOK(
NO CHAR(8) PRIMARY KEY,
TITLE VARCHAR2(50) NOT NULL,
AUTHOR VARCHAR2(20) ,
PUBLISH VARCHAR2(20),
PUB_DA ......
2.根据Oracle 数据库scott 模式下的emp 表和dept 表，完成下列操作：
(1) 查询20号部门的所有员工信息；
(2) 查询所有工种为CLERK 的员工的员工号、员工名和部门号；
(3) 查询奖金COMM 高于工资SAL 的员工信息；
......
数据类型
类型
描 述
bit
整型
bit 数据类型是整型，其值只能是0、1或空值。这种数据类型用于存储只有两种可能值的数据，如Yes 或No、True 或Fa lse 、On 或Off
int
整型
int 数据类型可以存储从- 231(-2147483648)到231 (21 ......
SQL中on条件与where条件的区别
数据库在通过连接两张或多张表来返回记录时，都会生成一张中间的临时表，然后再将这张临时表返回给用户。
在使用left jion时，on和where条件的区别如下：
1、 on条件是在生成临时表时使用的条� ......
