自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

xiaotuni的专栏,每天进步一点点

互相学习,共同进步,https://github.com/xiaotuni

  • 博客(10)
  • 资源 (8)
  • 收藏
  • 关注

转载 执行SQL后返回的列分别是:表名、列名、列类型、列长度、列描述、是否主键

/**//*谁可以帮我写个SQL执行后返回的列分别是:表名、列名、列类型、列长度、列描述、是否主键写完整来。就是我一拿过来就可以运行的那种!~!~谢谢哦。*/SELECT  (case when a.colorder=1 then d.name else  end) N表名, a.colorder N字段序号, a.name N字段名, (case when COLUMNPRO

2007-04-29 10:50:00 5007

原创 改程序的烦恼。

今天终于把进售发票改完了。星期一给我的,今天才给改完,真是要命呀,花了尽一个星期的时间才基本上改完。终于知道为什么经常听到这样的话改别人的代码宁可自己重新写一遍今天终于身有体会呀同一样个难度系数差不多,功能基本也差不多的模块,基本上不到一个星期就OK了(都是晚上做)。 可是改这个却和我重新写一遍所花的时间更差不多了,而且还不知道最终行不行。第一:要看懂他的代码、代码风格

2007-04-27 23:48:00 841

原创 批量更新数据

 update BuyPruduct set AmountInvoice = AmountInvoice - b.Amount from (        select BuyProtocolProductID,Amount from BuyInvoiceProduct          where BuyInvoiceID = @ImportValue) as b where BuyPr

2007-04-27 08:29:00 800

原创 昨天同学来了。

他来的目的,我想有三个,第一就是他来拿他的被子,因为我们五一就要走了,去工作了,没有地方帮他东西;第二就是也好久没有见面,这次算是我们三个人在一起聚聚,聊会天。我想最主要的目的是,明天一大早得去接他女朋友。如果从他上班的那里来的,没有那么早的公交车。吃的是驴肉火烧一人两上,每人一啤酒,一碗混顿,两盘凉菜。我有一个习惯,那就得吃完饭之后,再渴就吃得多点,如果是先渴再吃,那敢定得乘。那小样说我们三

2007-04-25 00:05:00 653

转载 生成静态html

方案1: /**////    ///   传入URL返回网页的html代码 ///    ///   URL  ///     public   static     string   getUrltoHtml(string   Url) ...{ errorMsg   =   ""; try ...{ System.Net.WebRequest   wReq   =   System.Ne

2007-04-22 11:58:00 1410

原创 今天去买自行车

叫了一个同学也是同事一样去,本来是我卖车得,可是人家没有看上我和,到看了他得,他得买了30元。 

2007-04-08 23:58:00 635

原创 昨天卖了个手机若机亚1112i

昨天卖了个手机若机亚1112i 339元 

2007-04-08 23:55:00 895

原创 DB2 学习笔记宿主变量、游标、 Drop、Create、Alter、锁、性能维护。

宿主变量。exec sqlupdate t1set c1=:newvaluewhere c1 = :oldvalue;Exec sqlselect lastname,firstnameinto :last,:fistfrom t1where empon=:id;游标得定义________________Exec sql Declare c1 cursor for select c1,c2

2007-04-04 21:54:00 2249

原创 DB2 当中Rollup得用法,得一些看法。

select DEPARTMENT,Name,sum(amount) as sum,count(*) as count from sale inner join Employee on liaohaibing.EMPLOYEE.ID = liaohaibing.SALE.EMPLOYEEIDinner join liaohaibing.DEPARTMENT onliaohaibing.DEPA

2007-04-02 11:28:00 1995

原创 Reporting Function

SELECT ID,DepartmentID,Pay,SUM(PAY) Over(Partition BY DepartmentID)as Total,Pay*100/SUM(Pay) Over(Partition by DepartmentID) as "Pct of c2"FROM TempTableWHERE DepartmentID IN(15,20);SUM(PAY) Over(Pa

2007-04-02 00:01:00 756

DB2 Universal Database v8 Handbook

Publisher : Prentice Hall PTR Pub Date : August 04, 2003 ISBN : 0-13-066111-2 Pages : 496 IBM DB2 Universal Database V8 offers breakthrough availability, manageability, performance, and scalability. Now, straight from IBM, there's a start-to-finish guide to DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, including database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. Using real-world examples, this book shows how to take full advantage of DB2 V8's most powerful enhancements. Philip K. Gunning brings together IBM's best tips and techniques for saving time and money in every facet of database design, development, deployment, and administration. Coverage includes: Leveraging DB2 V8's new Wizards, Advisors, and other automation/self-management features Using the enhanced DB2 XML Extender to build next-generation B2B applications Quickly creating Stored Procedures and UDFs with the new Development Center Exploiting multidimensional clustering, prefetching, materialized query tables, Java threading, and other performance improvements Using the DB2 improved monitoring and logging facilities Maximizing availability via online table and index reorganization and dynamic configuration Understanding the latest changes in the DB2 product family

2009-03-26

Oracle to DB2 UDB Conversion Guide

< Day Day Up > -------------------------------------------------------------------------------- Oracle to DB2 UDB Conversion Guide by Whei-Jen Chen et al. ISBN:0738499455 IBM Redbooks © 2003 (448 pages) This informative guide describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. It presents the best practices in migration strategy and planning, migration tools, and more. Table of Contents Oracle to DB2 UDB Conversion Guide Notices Preface Chapter 1 - Introduction Chapter 2 - Oracle Migration Project Planning Chapter 3 - MTK Chapter 4 - Porting with MTK Chapter 5 - Conversion Reference Chapter 6 - Data Conversion Chapter 7 - Application Conversion Chapter 8 - Script Conversion Chapter 9 - Testing Appendix A - DB2 UDB Product Overview Appendix B - Data Types Appendix C - Oracle Call Interface (OCI) Mapping Appendix D - Converter for SQL*Loader Appendix E - Terminology Mapping Appendix F - Example Oracle Database Appendix G - Additional Material Related Publications Index List of Figures List of Tables List of Examples -------------------------------------------------------------------------------- < Day Day Up >

2009-03-26

PL/SQL Developer 7.0 User’s Guide

英文版<br>PL/SQL Developer is an Integrated Development Environment (IDE) for developing stored program<br>units in an Oracle Database. Using PL/SQL Developer you can conveniently create the server-part of<br>your client/server applications.

2007-09-12

Using NetBeansTM IDE 5.5

Your Guide to Getting Work Done in NetBeans IDE<br/>Welcome to the Using NetBeans™ IDE 5.5 guide. This guide is designed to give you<br/>a more detailed introduction to the IDE than is available in the Quick Start guide by<br/>exploring the main aspects of the IDE. This guide is geared mostly to newcomers to<br/>NetBeans IDE 5.5, whether you are new to using IDEs or an experienced IDE user<br/>that is switching over from a different development environment. However, readers<br/>of this guide are assumed to have at least a basic understanding of the Java<br/>programming language and related technologies.

2007-04-28

Microsoft.NET.框架程序设计,中文版

大家可以下载看看--李建忠译

2007-04-28

IBM Lotus Domino 7 邮件服务器配置全程攻略

IBM Lotus Domino 7 邮件服务器配置全程攻略

2007-04-05

MySQL/PHP Database Applications 英文版

MySQL/PHP Database Applications Welcome to the world of IDG Books Worldwide. IDG Books Worldwide, Inc., is a subsidiary of International Data Group, the world’s largest publisher of computer-related information and the leading global provider of information services on information technology. IDG was founded more than 30 years ago by Patrick J. McGovern and now employs more than 9,000 people worldwide. IDG publishes more than 290 computer publications in over 75 countries. More than 90 million people read one or more IDG publications each month. Launched in 1990, IDG Books Worldwide is today the #1 publisher of best-selling computer books in the United States. We are proud to have received eight awards from the Computer Press Association in recognition of editorial excellence and three from Computer Currents’ First Annual Readers’ Choice Awards. Our bestselling ...For Dummies® series has more than 50 million copies in print with translations in 31 languages. IDG Books Worldwide, through a joint venture with IDG’s Hi-Tech Beijing, became the first U.S. publisher to publish a computer book in the People’s Republic of China. In record time, IDG Books Worldwide has become the first choice for millions of readers around the world who want to learn how to better manage their businesses. Our mission is simple: Every one of our books is designed to bring extra value and skill-building instructions to the reader. Our books are written by experts who understand and care about our readers. The knowledge base of our editorial staff comes from years of experience in publishing, education, and journalism — experience we use to produce books to carry us into the new millennium. In short, we care about books, so we attract the best people. We devote special attention to details such as audience, interior design, use of icons, and illustrations. And because we use an efficient process of authoring, editing, and desktop publishing our books electronically, we can spend more time ensuring superior content and less time on the technicalities of making books. You can count on our commitment to deliver high-quality books at competitive prices on topics you want to read about. At IDG Books Worldwide, we continue in the IDG tradition of delivering quality for more than 30 years. You’ll find no better book on a subject than one from IDG Books Worldwide.

2007-04-05

Linux的高级路由和流量控制HOWTO中文版

这个文档依着对公众有利用价值的目的而发布,但不提供任何担保,即使是在经销或者使用在特定场合时的潜在担保。

2007-04-05

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除