- 浏览: 2737995 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (1313)
- JS (65)
- CSS (6)
- html (30)
- dweamweaver工具相关 (2)
- Spry (1)
- DB (103)
- p2p (1)
- java (405)
- .net (3)
- oracle (24)
- struts (18)
- myeclipse (15)
- linux (49)
- SQL SERVER2008 (101)
- jsp (21)
- resume (1)
- other (1)
- ajax (3)
- 云计算 (2)
- excel (32)
- vss (1)
- 警戒 (1)
- eclipse (21)
- c (1)
- dialog designer (7)
- axis1.4 (4)
- webservice (11)
- CTI (1)
- svn (8)
- spring (27)
- tomcat (13)
- log4j (14)
- 网络应用 (7)
- mysql (59)
- bat (4)
- jdbc (1)
- 正式表达式 (1)
- hibernate (27)
- iphone (2)
- 系统应用 (107)
- servlet (3)
- vmware (2)
- php (12)
- JQuery (30)
- avaya (5)
- postgresql (19)
- java面试 (1)
- rose (1)
- Socket (1)
- xml (2)
- PowerDesign (3)
- visio (1)
- jstl (4)
- informix (2)
- assemble (2)
- English Study (2)
- IOS (9)
- CMMI (1)
- outlook (4)
- poi (1)
- hadoop (5)
- SAE (3)
- jor (1)
- jquery mobile (1)
- git (11)
- mina (1)
- ibatis (2)
- wordpress (2)
- 支付宝 (1)
- struts2 (14)
- apns (1)
- html5 (1)
- xampp (2)
- uml (2)
- 项目管理 (1)
- 敏捷开发 (1)
- 设计模式 (2)
- spark (1)
- maven (9)
- 微信公众平台 (1)
- json (2)
- junit (1)
- quartz (2)
- redis (2)
- memcache (1)
- android (3)
- 红杏 (1)
- postman (1)
- mybatis (5)
- iplat4j (1)
- windows (1)
- logback (1)
- Netty (1)
- wiki (1)
- dubbo (1)
- sonar (2)
- jenkins (2)
- mac (10)
- office (4)
- groovy (1)
- intellij (6)
- zookeeper (2)
- 诛仙 (1)
- MQ (2)
- docker (1)
- 2222 (0)
最新评论
-
代码改变生活:
虽然代码敲的头疼的要命,但是依然要感谢你,感谢您共享!!!!开 ...
jxl读取excel日期相差8小时 -
www3837:
org.slf4j.Logger 下载 -
hyztty:
wait_timeout = 86400 interacti ...
druid连接池 -
niaodanwangzi:
连接池可不是给你检测连接状态用的。是为了连接复用,减少连接数。 ...
druid连接池 -
supermine0903:
学习了 啦啦啦
多个路由器同时上网
SELECT ISNULL(ED.RegNo,'') as RegNo,ISNULL(ED.RefNo,'') as RefNo , ISNULL(ED.RoundNo,'') as RoundNo, ISNULL(S.RefDate_Sett,'') as RefDate_Sett , ISNULL(EH.PayAccount,'') as PayAccount , ISNULL(EH.PayAccountNmCN,'') as PayAccountNmCN , ISNULL(EH.PayAccountNmEN,'') as PayAccountNmEN , ISNULL(EH.ClCmtNo,'') as ClCmtNo, ISNULL(EH.ClCmtAccSbjtName,'') as ClCmtAccSbjtName, ISNULL(EH.ReceiptAccount,'') as ReceiptAccount , ISNULL(EH.ReceiptAccSbjt,'') as ReceiptAccSbjt , ISNULL(R.BillTypeNm,'') as BillTypeNm , ISNULL(R.BillTypeVal,'') as BillTypeVal , ISNULL(R.BAPerson,'') as BAPerson , ISNULL(R.AcpnBillNo,'') as AcpnBillNo, R.BillAmt as BillAmt, ISNULL(R.BilExecDate,'') as BilExecDate, ISNULL(R.BilMatDate,'') as BilMatDate, ISNULL(R.BillPayerIsDiffPlaceNm,'') as BillPayerIsDiffPlaceNm, ISNULL(EH.DiscBeginDate,'') as DiscBeginDate , ISNULL(EH.ExistRecourseVal,'') as ExistRecourseVal , ISNULL(ED.DiscMatDate,'') as DiscMatDate , ISNULL(S.BilSettDate,'') as BilSettDate , ISNULL(S.Account1,'') as Account1 , ISNULL(S.AcTtlSub1,'') as AcTtlSub1 , S.AccAmt1 as AccAmt1 , ISNULL(S.Account2,'') as Account2, ISNULL(S.AcTtlSub2,'') as AcTtlSub2, S.AccAmt2 as AccAmt2, ISNULL(S.Account3,'') as Account3 , ISNULL(S.AcTtlSub3,'') as AcTtlSub3 , S.AccAmt3 as AccAmt3 , ISNULL(S.IsExpiredVal,'') as IsExpiredVal , ISNULL(S.ExpiInterestRate,0) as ExpiInterestRate , ISNULL(S.ExpiPunishIntt,0) as ExpiPunishIntt , ISNULL(S.ExpiPunishAccount,'') as ExpiPunishAccount, ISNULL(S.ExpiPunishAcTtlSub,'') as ExpiPunishAcTtlSub, ISNULL(S.IsBuybackVal,'') as IsBuybackVal, ISNULL(S.RefusePayRsnDate,'') as RefusePayRsnDate, ISNULL(S.BillOriBackDate,'') as BillOriBackDate, ISNULL(S.BuyBackDate,'') as BuyBackDate, ISNULL(S.MakerId,'') as MakerId , ISNULL(S.MakerNm,'') as MakerNm , ISNULL(S.ChkerId,'') as ChkerId , ISNULL(S.ChkerNm,'') as ChkerNm , ISNULL(S.ApproverId,'') as ApproverId , ISNULL(S.ApproverNm,'') as ApproverNm , ISNULL(S.RejecterId,'') as RejecterId , ISNULL(S.RejecterNm,'') as RejecterNm , ISNULL(S.SettStasValue,'') as SettStasValue , ISNULL(S.SettStasName,'') as SettStasName , ISNULL(S.Remark1,'') as Remark1 , ISNULL(S.Remark2,'') as Remark2 , ISNULL(S.Remark3,'') as Remark3 , ISNULL(S.Remark4,'') as Remark4 , ISNULL(S.Remark5,'') as Remark5 , ISNULL(S.DelReason,'') as DelReason , ISNULL(S.UpdDate,'') as UpdDate , ISNULL(S.UpdateCount,0) as UpdateCount FROM B_DiscountExecH EH INNER JOIN B_DiscountExecD ED ON EH.DiscountNo=ED.DiscountNo INNER JOIN B_DiscountReg R on R.RegNo=ED.RegNo INNER JOIN B_DiscountSett S on S.RegNo=ED.RegNo WHERE R.RegNo='B11091316014189' AND EH.DiscountNo='000000000011' AND ED.BookingBranch='8879' AND ED.AmendCount=( SELECT isnull(MAX(AmendCount),0) as AmendCount FROM B_DiscountExecD WHERE RegNo='B11091316014189'AND BookingBranch='8879'AND DiscountNo='000000000011' ) AND S.UpdateCount= ( SELECT isnull(MAX(UpdateCount),0) as UpdateCount FROM B_DiscountSett WHERE RegNo='B11091316014189'AND BookingBranch='8879' )
和下面的一段:
SELECT ISNULL(ED.RegNo,'') as RegNo,ISNULL(ED.RefNo,'') as RefNo , ISNULL(ED.RoundNo,'') as RoundNo, ISNULL(S.RefDate_Sett,'') as RefDate_Sett , ISNULL(EH.PayAccount,'') as PayAccount , ISNULL(EH.PayAccountNmCN,'') as PayAccountNmCN , ISNULL(EH.PayAccountNmEN,'') as PayAccountNmEN , ISNULL(EH.ClCmtNo,'') as ClCmtNo, ISNULL(EH.ClCmtAccSbjtName,'') as ClCmtAccSbjtName, ISNULL(EH.ReceiptAccount,'') as ReceiptAccount , ISNULL(EH.ReceiptAccSbjt,'') as ReceiptAccSbjt , ISNULL(R.BillTypeNm,'') as BillTypeNm , ISNULL(R.BillTypeVal,'') as BillTypeVal , ISNULL(R.BAPerson,'') as BAPerson , ISNULL(R.AcpnBillNo,'') as AcpnBillNo, R.BillAmt as BillAmt, ISNULL(R.BilExecDate,'') as BilExecDate, ISNULL(R.BilMatDate,'') as BilMatDate, ISNULL(R.BillPayerIsDiffPlaceNm,'') as BillPayerIsDiffPlaceNm, ISNULL(EH.DiscBeginDate,'') as DiscBeginDate , ISNULL(EH.ExistRecourseVal,'') as ExistRecourseVal , ISNULL(ED.DiscMatDate,'') as DiscMatDate , ISNULL(S.BilSettDate,'') as BilSettDate , ISNULL(S.Account1,'') as Account1 , ISNULL(S.AcTtlSub1,'') as AcTtlSub1 , S.AccAmt1 as AccAmt1 , ISNULL(S.Account2,'') as Account2, ISNULL(S.AcTtlSub2,'') as AcTtlSub2, S.AccAmt2 as AccAmt2, ISNULL(S.Account3,'') as Account3 , ISNULL(S.AcTtlSub3,'') as AcTtlSub3 , S.AccAmt3 as AccAmt3 , ISNULL(S.IsExpiredVal,'') as IsExpiredVal , ISNULL(S.ExpiInterestRate,0) as ExpiInterestRate , ISNULL(S.ExpiPunishIntt,0) as ExpiPunishIntt , ISNULL(S.ExpiPunishAccount,'') as ExpiPunishAccount, ISNULL(S.ExpiPunishAcTtlSub,'') as ExpiPunishAcTtlSub, ISNULL(S.IsBuybackVal,'') as IsBuybackVal, ISNULL(S.RefusePayRsnDate,'') as RefusePayRsnDate, ISNULL(S.BillOriBackDate,'') as BillOriBackDate, ISNULL(S.BuyBackDate,'') as BuyBackDate, ISNULL(S.MakerId,'') as MakerId , ISNULL(S.MakerNm,'') as MakerNm , ISNULL(S.ChkerId,'') as ChkerId , ISNULL(S.ChkerNm,'') as ChkerNm , ISNULL(S.ApproverId,'') as ApproverId , ISNULL(S.ApproverNm,'') as ApproverNm , ISNULL(S.RejecterId,'') as RejecterId , ISNULL(S.RejecterNm,'') as RejecterNm , ISNULL(S.SettStasValue,'') as SettStasValue , ISNULL(S.SettStasName,'') as SettStasName , ISNULL(S.Remark1,'') as Remark1 , ISNULL(S.Remark2,'') as Remark2 , ISNULL(S.Remark3,'') as Remark3 , ISNULL(S.Remark4,'') as Remark4 , ISNULL(S.Remark5,'') as Remark5 , ISNULL(S.DelReason,'') as DelReason , ISNULL(S.UpdDate,'') as UpdDate , ISNULL(S.UpdateCount,0) as UpdateCount FROM B_DiscountExecH EH INNER JOIN B_DiscountExecD ED ON EH.DiscountNo=ED.DiscountNo INNER JOIN B_DiscountReg R on R.RegNo=ED.RegNo INNER JOIN B_DiscountSett S on S.RegNo=ED.RegNo WHERE R.RegNo='B11091316014189' AND EH.DiscountNo='000000000011' AND ED.BookingBranch='8879' AND ED.AmendCount=( SELECT isnull(MAX(AmendCount),0) as AmendCount FROM B_DiscountExecD WHERE RegNo='B11091316014189'AND BookingBranch='8879'AND DiscountNo='000000000011' ) AND S.UpdateCount= ( SELECT isnull(MAX(UpdateCount),0) as UpdateCount FROM B_DiscountSett WHERE ED.RegNo='B11091316014189'AND ED.BookingBranch='8879' )看上去意思差不多,到底有何区别?出来的结果有时也不一样。
发表评论
-
sql2000 驱动下载
2013-11-21 10:12 877refurl:http://down.51ct ... -
sqlserver2008 创建数据库权限
2013-11-19 10:00 12681、用grant 命令。 2、随便点击某个数据库-& ... -
mysql 索引详解
2013-11-17 20:29 6353.1、建索引的方式有几种?分别试验一下 ... -
mysql 给字段添加default
2013-10-31 14:15 1304alter table t_incoming_rec ... -
java postgresql
2013-09-26 13:41 1141refurl:http://www.blo ... -
oracle timestamp
2013-09-05 15:49 1565环境:Oracle11g 1、首先,orac ... -
postgresql如何让主键自增
2013-07-09 16:29 53149法一: CREATE TABLE customers ... -
SQLSERVER 查看当前连接数
2013-07-05 09:13 2480Select * from sys.dm_exec_c ... -
sqlserver2012 oracle11g
2013-06-13 17:51 21851、 SQLServer2008过去4年 ... -
jndi连接池正确配置
2013-06-06 14:10 1410<Resource name="jdb ... -
sqlserver2008 进程监控
2013-06-05 16:52 1506在SQLSERVER2008中,在工具栏上点击“活动监视器 ... -
java informix
2013-05-21 11:26 37091、下载jdbc 驱动包(下面链接任选一种): ... -
SQL远程备份
2013-05-16 10:12 1230利用用户名穿越,可以实施SQL 的远程备份。 ba ... -
SQL 各种join
2013-03-14 17:04 1186MyTable1: id name 001 wdj ... -
SQL int bigint字段
2013-03-14 16:50 1845无论在Mysql还是Sqlserver中 整数都是 ... -
mysql 如何建立外键
2013-03-07 14:30 1726最新的成功写法,不要每次都来找了: alter tab ... -
Mysql date_format
2013-03-04 22:51 14431、Mysql数据库中有格式化日期的语法: date_f ... -
Mysql数据库隔离级别
2013-03-03 13:01 18681、隔离级别分以下几 ... -
修改数据库字段长度
2013-02-24 14:53 1528环境:mysql5.0 语法如下: alt ... -
foreign key
2013-02-24 11:23 1127foreign key这个东西平时使用较少。 今天稍 ...
相关推荐
SQL 基础 SQL 首页 SQL 简介 SQL 语法 SQL select SQL distinct SQL where SQL AND & OR SQL Order By SQL insert SQL update SQL delete SQL 高级 SQL Top SQL Like SQL 通配符 SQL In SQL Between ...
在学习和研究环境中,SQL Prompt提供了多种功能,包括自动完成、代码格式化、性能建议等,但使用者必须注意,这个版本仅供非商业用途。 1. **自动完成**:SQL Prompt提供智能感知功能,可以在编写SQL语句时自动补全...
SQL Server 导入超大 SQL 脚本文件 SQL Server 是一种关系型数据库管理系统,广泛应用于各种行业。然而,在实际应用中,我们经常会遇到导入超大 SQL 脚本文件的问题。本文将介绍如何使用 osql 工具来导入超大 SQL ...
SQL优化是数据库管理中的关键环节,它涉及到提升查询性能、减少资源消耗以及改善系统整体效率。SQL优化软件和工具能够帮助数据库管理员(DBA)和开发人员找出性能瓶颈,优化查询逻辑,从而提高数据库系统的响应速度...
在IT行业中,数据库管理系统是核心组成部分,SQL Server和Oracle分别是微软和甲骨文公司推出的两款广泛应用的关系型数据库系统。在企业级应用中,有时需要在不同的数据库系统间进行数据迁移或兼容性处理,这就涉及到...
SQLPrompt for SQLServer2016 智能提示插件 SQL2016 提示 SQLPrompt最新版本 绿色版 SQL Prompt 是一款拥有SQL智能提示功能的SQL Server和VS插件。SQL Prompt能根据数据库的对象名称,语法和用户编写的代码片段自动...
对SQL注入漏洞给相应检测及防御技术进行研究,通过本地创建的实验环境,将Pubs数据库作为案例和多种渗透方法实现SQL注入实验。以SQL注入攻击特点为基础,提出四种具体防御措施。实验表示,此防御措施Web应用系统能够...
商城sql商城sql商城sql商城sql商城sql商城sql商城sql商城sql
SQLTracker是一款专为数据库操作监控设计的工具,它在IT领域中主要用于跟踪和记录SQL语句的执行情况。SQL(Structured Query Language)是用于管理关系数据库的编程语言,包括查询、更新、插入和删除数据等操作。SQL...
《SQLMonitor:Oracle数据库SQL跟踪与分析利器》 在IT行业中,数据库的高效管理与优化是至关重要的。针对Oracle数据库,有一款名为SQLMonitor的工具,它专为跟踪和监控SQL语句而设计,帮助开发者和DBA们找出程序...
在Kettle中配置SQL Server数据库连接时,我们需要依赖特定的数据库驱动,这就是SQL JDBC驱动。 SQL JDBC驱动是微软提供的Java Database Connectivity (JDBC) 驱动,使得Java应用程序能够与SQL Server进行交互。有两...
SqlParser是一款基于C++实现的SQL语法解释器,它的主要任务是解析SQL语句,将其转化为计算机可理解的形式,从而能够执行相应的数据库操作。在数据库系统中,SQL(Structured Query Language)是用于管理关系数据库的...
SQL Server驱动包`sqljdbc4.jar`是微软官方提供的Java数据库连接器(JDBC),用于在Java应用程序中与Microsoft SQL Server进行通信。JDBC是Java编程语言中的一个标准API,它使得开发人员能够以标准化的方式访问各种...
为了有效地检测和防范此类攻击,安全研究人员和工程师们常常会采用SQL注入字典(SQL Injection Dictionary)来进行模糊测试(Fuzzing)。本文将深入探讨SQL注入字典fuzz的相关知识点。 #### 二、SQL注入基础 SQL...
Microsoft SQL Server Native Client (SQL Native Client) 是一个同时包含 SQL OLE DB 访问接口和 SQL ODBC 驱动程序的动态链接库 (DLL)。它对使用本机代码 API(ODBC、OLE DB 和 ADO)连接到 Microsoft SQL Server ...
在数据库管理领域,Oracle SQL和MySQL SQL是两种广泛使用的SQL方言,它们在语法和功能上存在一定的差异。当需要将一个基于Oracle SQL的应用程序迁移到MySQL环境时,就需要进行SQL语句的转换工作。本项目提供了一个...
SQL Server连接工具是数据库管理员和开发人员用于与Microsoft SQL Server交互的重要软件。这些工具提供了多种功能,包括数据库的创建、管理、查询、备份、恢复以及性能优化等。在本篇文章中,我们将深入探讨SQL ...
Sql Server 2005 打开 Sql Server 2008 mdf 文件数据库转换是指将 Sql Server 2008 中的数据库文件(mdf 文件)转换为 Sql Server 2005 可以识别的格式,以便在 Sql Server 2005 中使用。这种转换过程需要使用 Sql ...