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.一道SQL语句面试题，关于group by
表内容：
2005-05-09 胜
2005-05-09 胜
2005-05-09 负
2005-05-09 负
2005-05-10 胜
2005-05-10 负
2005-05-10 负
如果要生成下列结果, 该如何写sql语句?
胜 负
2005-05-09 2 2
2005-05-10 ......
背景：系统要支持多种数据库，统一insert的时候获取自动增长列的处理方式
问题1：insert select方案
sqlserver2000能够使用insertSql SELECT @@IDENTITY AS 'Identity'的方式来获得，但是mysql则只能使用executeUpdate(insertSql);
executeQuery('SELECT last_insert_id() ')这样的方式，否则会抛出异常：java.sql.SQ ......
(1)char、varchar、text和nchar、nvarchar、ntext
char和varchar的长度都在1到8000之间，它们的区别在于char是定长字符数据，而varchar是变长字符数据。所谓定长就是长度固定 的，当输入的数据长度没有达到指定的长度时将自动以英文空格在其后面填充，使长度达到相应的长度；而变长字符数据则不会以空格填充。 text� ......
MS-SQL中sa登录失败:
该错误产生的原因是由于SQL Server使用了"仅 Windows"的身份验证方式,
因此用户无法使用SQL Server的登录帐户（如 sa ）进行连接.解决方法如下所示:
1.在服务器端使用企业管理器,并且选择"使用 Windows 身份验证"连接上 SQL Server
操作步骤:
在企业管理器中
--右键你的服务器实例(就是那 ......
