摘要： http://sqltutorials.blogspot.com/2007/06/sql-union-all.html--http://sqltutorials.phick1.com/ SQL UNION ALL SQL UNION ALL is combine the results of two queries together without filter out the same value(no distinct behavior). The difference between UNION ALL and UNION is UNION only selects distinct . 阅读全文

摘要： What Makes a Great Software Requirements Specification?There are many good definitions of System and Software Requirements Specifications that will provide us a good basis upon which we can both define a great specification and help us identify deficiencies in our past efforts. There is also a lot . 阅读全文

摘要： MindTouch Open Source CMS MindTouch.com/Open_Source_CMSAward-Winning,Collaborative,WYSIWYG Moderation, Analytics. Free Trial!RichCopy is a visual file copying utility that helps you copy or move files at a much faster rate. It has existed since the days of Windows 95 but (unless you're working a 阅读全文

摘要： MindTouch Open Source CMS MindTouch.com/Open_Source_CMSAward-Winning,Collaborative,WYSIWYG Moderation, Analytics. Free Trial!RichCopy is a visual file copying utility that helps you copy or move files at a much faster rate. It has existed since the days of Windows 95 but (unless you're working a 阅读全文

摘要： C++的Cpp文件#include<iostream>#defineMODULEAPI#include"tracewrite.h"usingnamespacestd;voidFunc1(){cout<<"iamfunction1"<<endl;}voidFunc2(){cout<<"iamfunction2"<<endl;}voidFunc3(){cout<<"iamfunction3"<<endl;}对应的头文件：（.h)#ifn 阅读全文

摘要： Initializes a new instance of the ProcessStartInfo class.This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.Overload List NameDescriptionProcessStartInfo()Initializes a new instance of the ProcessStartInfo . 阅读全文

摘要： 1. 在工程中Reference dll: 1).specify version: true or false should be same.Other wise, there will be conflick between these dlls expecily that have depence. 2). We can set all of them are true or all false.2.SqlException: The parameterized query ## expects the pa... RSS Resolved.publicvoidUpdateTableInf 阅读全文

摘要： http://www.cnblogs.com/mecity/archive/2011/07/07/2099598.htmlEntityFramework之犹豫不决 1）.WorkFlow入门Step.1—My Frist WorkFlow Trip！http://www.cnblogs.com/hegezhou_hot/archive/2011/05/31/2064949.html2). http://www.cnblogs.com/gaizai/archive/2011/05/31/2064931.htmlSQL Server 表分区注意事项 3).SqlServer2008 数据库同步的两 阅读全文

摘要： ROW_NUMBER (Transact-SQL)USE AdventureWorks2008R2;GOWITH OrderedOrders AS( SELECT SalesOrderID, OrderDate, ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber' FROM Sales.SalesOrderHeader ) SELECT * FROM OrderedOrders WHERE RowNumber BETWEEN 50 AND 60; 阅读全文

摘要： http://www.cnblogs.com/MR_ke/archive/2011/05/29/2062085.html我们做软件开发的，大部分人都离不开跟数据库打交道，特别是erp开发的，跟数据库打交道更是频繁，存储过程动不动就是上千行，如果数据量大，人员流动大，那么我么还能保证下一段时间系统还能流畅的运行吗？我么还能保证下一个人能看懂我么的存储过程吗？那么我结合公司平时的培训和平时个人工作经验和大家分享一下，希望对大家有帮助。 要知道sql语句，我想我们有必要知道sqlserver查询分析器怎么执行我么sql语句的，我么很多人会看执行计划，或者用profile来监视和调优查询语句或者存储过 阅读全文