huayang912-CSDN博客

原创 SQL SERVER – Random Number Generator Script – SQL Query

Random Number Generator There are many methods to generate random number in SQL Server. Method 1 : Generate Random Numbers (Int) between Rang ---- Create the variables for the random number generation DECLARE @Random INT; DEC

2010-11-12 14:40:00 901

原创 Tracking Visitors with ASP.NET

MARKETPLACE AutoCAD® Trial Download Free 30 Day Trial Of AutoCAD 2011. Save Time And Increase Productivity Autodesk.com/AutoCAD Microsoft SQL Server® 2008 - Free Trial Download the Free 180-day Trial of SQL Server® 2008 Enterprise Edit

2010-06-18 15:33:00 2656

原创 A Practical Approach to Computer Systems Design and Architecture

Table of Contents 2.1. What Solution Providers Do Today? 2.2. Why We Should Design Systems Properly? Do I have to answer this?3.1. Breaking the System with Easy Concepts5.1. Object Oriented Programming (OOP) Concepts 5.2. Design Pat

2010-06-18 11:33:00 2172

原创 sql_add_remove_descripton

DECLARE @table VARCHAR(50) , @field VARCHAR(50) SELECT @table = MIN(name) FROM dbo.sysobjects WHERE xtype = 'U' WHILE @table IS NOT NULL BEGIN SELECT @field = MIN(COLUMN_NAME

2010-06-09 09:36:00 393

原创去掉sql server 字段中的回车

比如 CustomerInfo 中有字段 Customer_DutyEMail 中可能有回车，则用如下语句去掉回车 UPDATE dbo.CustomerInfo SET Customer_DutyEMail = replace(replace(Customer_DutyEMail,char(10),''),char(13),'')

2010-06-09 09:33:00 1098

原创 SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database

SERVER – 2008 – Configure Database Mail – Send Email From SQL DatabaseAugust 23, 2008 by pinaldave Today in this article I would discuss about the Database Mail which is used to send the Email

2010-05-07 12:55:00 977

原创解决大批量数据TransactionScope出错问题

TransactionScope 是.net 提供的可提升事务环境，开发软件的时候非常方便，但是在大数据量处理的时候，会莫名我出错，检查代码没有任何的错误解决这个错误的方法：不用TransactionSc

2010-04-06 22:30:00 2854

原创 How To Split column In SQL

SET NOCOUNT ON DECLARE @Table table (Col001 varchar(100) NOT NULL) INSERT INTO @Table VALUES(AABY TAMARA J)INSERT INTO @Table VALUES(AADNESEN MARJORIE)INSERT INTO @Table VALUES(Paol

2010-04-02 14:19:00 732

原创 WIN SERVER 2003 安装配置IIS

1.在添加删除里添加安装windows 组件——》应用程序服务器——》internet information services(IIS)-—》安装common files, iis manager, world wild web services 2.配置好虚拟目录，在虚拟目录右击，属性，asp.net 页，注意选asp.net 版本2.0 3. cd [drive:]/

2010-03-24 16:53:00 468

原创 ReportViewer 错误

Could not load file or assembly Microsoft.ReportViewer.ProcessingObjectModel.dll http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/38797563-69ab-4b40-8807-22ea2966475a

2010-03-24 16:39:00 605

原创 T4 template for generating SQL view from C# enumeration

Database tables often contain columns that store “codes”, or values with special meaning. In application code, these special values can be encapsulated as enumerations. This article demonstrates how

2010-02-07 20:19:00 1379

转载 SQL Server 2005: Recursive Hierarchies to XML

Suppose we have a recursive hierarchy stored in a relational database and we want to write it to XML. This might be for a variety of reasons – e.g. as a pre-cached input to a UI control, to export to

2010-02-07 19:32:00 459

转载 StickOut: A Desktop Sticky Notes Application in the .NET Framework 2.0

AL ZabirOmarAlZabir@gmail.comMarch 2006Applies to:Microsoft .NET Framework 2.0Microsoft .NET RemotingMicrosoft OfficeMicrosoft Visual StudioWindows FormsSummary: StickOut is a desktop sticky n

2009-12-01 22:28:00 5504 6

原创 ReadCompareExcelToDictionary (Resource file export and import)

private void ReadCompareExcelToDictionary() { if (File.Exists(oldFileTxt.Text)) { sourceSheetDicionary = new Dictionary>(); // Opening the ex

2009-12-01 22:27:00 451 4

原创 Step-by-step Introduction to Delegates and Lambda Expressions

Many so often during my lectures an courses I provide to - what I would call - main stream developers I realize that delegates, anonymous methods and lambda expressions are concepts either complete

2009-11-26 22:29:00 626 12

Apress.Pro.WCF.Practical.Microsoft.SOA.Implementation.Jan.rar

2012-03-21

wcf中文版入门，英文版提高

2012-03-21

Eziriz.Reactor.v4.2.8.4.and NET.Reflector7.0

.net 反编译工具和代码混淆工具破解版

2012-03-14

RedGate 4.0 全套产品破解版

RedGate （包括SQL Prompt 4.0）全套产品破解版，支持在线激活。用 WinRar 解压缩。

2011-10-08

RedGate SQL Doc 2.0

RedGate SQL Doc 2.0 破解修改版（基于最新RedGate SQL Doc 2.0程序） 1）修复了原有程序中中文注释乱码的bug 2）修复了原有程序生成chm文件的几个bug：a）内容列表中中文乱码 b）索引列表中的中文乱码，并且不能用中文查找 c）搜索中不能使用中文查找，并且结果集中的中文字符乱码

2011-01-27

AjaxFileUploadHelper

While everyone has their own preferred way to tackle the UpdatePanel / FileUpload issue

2011-01-23

DayPilot Month Picker2-1.0.21 source code and demo

DayPilot Calendar is an Outlook-like day/week view. Columns are customizable (any number of days/resources). Supports drag&drop AJAX operations (moving, resizing), context menu, integrated message bar.

2010-12-30

TimeTracker 源码

TimeTracker,Project manage tool , project member time event entry log, time track.

2010-12-29

RegCleaner RegCleaner

This program is called "RegCleaner," Microsoft's registry cleaner is called "RegClean." My program has nothing to do neither with "RegClean," nor with Microsoft. I am ready to change my program's name if Microsoft requests it. Microsoft is a registered trademark of the Microsoft Corporation. All other trademarks belong to their respective owners.

2010-09-18

SqlHelper sql server data access wrapper

SqlHelper sql server data access wrapper SqlHelper sql server data access wrapper SqlHelper sql server data access wrapper

2010-06-17

UltraCompareProfessional6.rar

UltraCompareProfessional6.rar UltraCompareProfessional6.rar UltraCompareProfessional6.rar

2010-05-27

VisualSVN.1.7.3.Crack

VisualSVN.1.7.3.Crack VisualSVN.1.7.3.Crack VisualSVN.1.7.3.Crack

2010-05-27

IssueTracker Issue Tracker 问题跟踪系统

IssueTracker Issue Tracker 问题跟踪系统， Issue-Tracker is a support issue tracking system written in asp.net 2.0 , with MSSQL backend. The system is designed to be user friendly,simpley use Issue-Tracker also includes many features that will allow customer/technical support organizations to take care of customer issues quickly and easy. Some of these features include things like file uploads, email parsing, email notifications when a bug reported by tester,bug status changed. 解压文件后 data文件夹下面有SQL SERVER 数据库文件，附加到SQL SERVER 上即可，然后更新连接字符串<add key="ConnectionString" value="Data Source=.;Initial Catalog=IssueTrackerStarterKit2;Integrated Security=True"/> 建好虚拟目录后，根据实际访问路径，填写根目录，更改： <add key="IntranetDesktopDefaultUrl" value="http://192.168.0.6/IssueTracker/"/> <add key="InternetDesktopDefaultUrl" value="http://218.242.134.87:8023/IssueTracker/"/> 前面一项是内网访问地址，后面一项是外网访问地址，现有用户:test3,密码：111111

2010-01-21

-------------------------------------------------------

SqlCe_多机版多连接单个开发(EntLib)。。。。。。。。。。。 SqlCe_多机版多连接单个开发(EntLib)。。。。。。。。。。 SqlCe_多机版多连接单个开发(EntLib)。。。。。。。。。。

2010-01-18

-------------------------------------------------------)

SqlCe_多机版多连接多个开发(EntLib)。。。。。。。。。。。。。。SqlCe_多机版多连接多个开发(EntLib)。。。。。。。。。SqlCe_多机版多连接多个开发(EntLib)

2010-01-13

-------------------------------------------------------

SqlCe_多机版多连接多个开发................ SqlCe_多机版多连接多个开发............... SqlCe_多机版多连接多个开发.................

2010-01-12

entlibcontrib2009-05src_sample

entlibcontrib2009-05src_sample... entlibcontrib2009-05src_sample.... Based on Enterprise Library 3.1, DAEE enables developers to access databases faster and safer. DAEE supports multiple database sources including ACCESS/ SQLSERVER2000/ SQLSERVER2005/ ODBC/ ORACLE/ EXCEL etc. You can configure connection strings in WEB.CONFIG/ APP.CONFIG through Microsoft Enterprise Library Configuration Tool. DAEE have many other features, including the following ones: 1. Enabling operations crossing multiple databases at the same time. 2. Supporting executions of multiple operations with a transaction. 3. Supporting pagination of single table operation, skip of specific records (only SQLSERVER2005 is available now). 4. High security level, preventing from SQL Injection Attack. 5. Other features. System Requirements * Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP Note: If you already have the Enterprise Library 3.0 installed, you must uninstall it before installing the Enterprise Library 3.1. However, you can install the Enterprise Library 3.0 or the Enterprise Library 3.1 when 2.0 is already installed.

2010-01-12