摘要: /****** Object: StoredProcedure [dbo].[up_Page2005] Script Date: 11/28/2013 17:10:47 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[up_Page2005] ( @TableName VARCHAR(MAX) , --表名 @Fields VARCHAR(5000) = '*' , --字段名(全部字段为*) ... 阅读全文
posted @ 2013-11-28 17:17 特务小强 阅读(949) 评论(0) 推荐(1) 编辑
摘要: Update: Due to a glitch in my code I miscalculated the difference. It has been updated. See full history of the code in theGist. The outcome is still essentially the same :)I was talking withDavid Fowlerwhen he mentioned something I found surprising: “Lambdas are more efficient than Method Groups”. 阅读全文
posted @ 2013-09-18 16:42 特务小强 阅读(397) 评论(0) 推荐(0) 编辑
摘要: 阅读全文
posted @ 2013-09-11 10:03 特务小强 阅读(366) 评论(0) 推荐(0) 编辑
摘要: 一、用属性代替可访问的字段 1、.NET数据绑定只支持数据绑定,使用属性可以获得数据绑定的好处; 2、在属性的get和set访问器重可使用lock添加多线程的支持。 二、readonly(运行时常量)和const(编译时常量) 1、const只可用于基元类型、枚举、字符串,而readonly则可以是任何的类型; 2、const在编译时将替换成具体的常量,这样如果在引用中同时使用了const和readonly两种值,则对readonly的再次改变将会改变设计的初衷,这是需要重新编译所更改的程序集,以重新引用新的常量值。 3、const比readonly效率高,但失去了应用的灵活性。 三、... 阅读全文
posted @ 2013-08-31 20:08 特务小强 阅读(1123) 评论(2) 推荐(2) 编辑
摘要: Let me start by saying that the idea I used in this article is not originally mine, but since I have only heard of it and have not been able to find any actual examples of its implementation anywhere I wrote the code to handle it.With that out of the way - here's what this is about: Anyone who&# 阅读全文
posted @ 2013-08-14 13:39 特务小强 阅读(566) 评论(0) 推荐(0) 编辑
摘要: 这段正则使用了前瞻的方法,匹配的数字后面必须有3的n倍个数字,保证3个为1组,并将匹配出来的数字后面添加逗号。(正负数通杀) 1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Text; 5 using System.Text.RegularExpressions; 6 using System.Threading.Tasks; 7 8 namespace MyRegexTest 9 {10 class Program11 {12 st... 阅读全文
posted @ 2013-07-14 16:02 特务小强 阅读(1705) 评论(0) 推荐(0) 编辑
摘要: using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace RandTest{ class Program { static void Main(string[] args) { int m; do { Console.WriteLine("请输入要产生随机数的数量(大于0的数字)... 阅读全文
posted @ 2013-07-11 23:25 特务小强 阅读(723) 评论(2) 推荐(0) 编辑
摘要: ProblemAs we are looking through the new features in SQL Server 2008 we found a potentially interesting one called Change Data Capture. Can you give us a detailed explanation of how we go about using this one?SolutionChange Data Capture is a new feature in SQL Server 2008 that records insert, update 阅读全文
posted @ 2013-05-21 09:04 特务小强 阅读(460) 评论(0) 推荐(0) 编辑
摘要: 1 @echo off 2 set work_path=E:\DataFile\0003003 E: 4 cd %work_path% 5 for /R %%s in (*idx*.csv) do ( 6 echo %%s7 copy "%%s" "E:\DataFile\000300"8 )9 pause View Code 阅读全文
posted @ 2013-05-17 09:57 特务小强 阅读(239) 评论(0) 推荐(0) 编辑
摘要: Attribute VB_Name = "basMD5"Option ExplicitOption Base 0' A VB6/VBA procedure for the MD5 message-digest algorithm' as described in RFC 1321 by R. Rivest, April 1992' First published 16 September 2005.' Updated 2010-10-20 to fix ">" vs ">=" issue i 阅读全文
posted @ 2013-02-17 13:36 特务小强 阅读(459) 评论(0) 推荐(0) 编辑