ASP.net , C#, and VB.net , and Java, and SQL

摘要： The CLR process provides communications to .NET libraries. This is a new feature in SQL Server 2005 and allows developers to extend the power of the database engine by writing high-level code that can be called inside T-SQL just like a stored procedure or a function. Developers compile the code and 阅读全文

摘要： Reference: Administrator's Guide to SQL Server 2005A trigger is another set of T-SQL code similar to a stored procedure, but rather than being called by the user, it executes on certain conditions. The two kinds of conditions are when users alter data, called Data Manipulation Language (DML) operati 阅读全文

摘要： select CONVERT(Datetime, '1 '+ LEFT('Jul',3) + ' ' + RIGHT('10',2), 106)2010-07-01 00:00:00.0002010-07-01 13:00:00.000CONVERT(varchar(5), xxxxxx, 108)13:00 阅读全文

摘要： SQL UNIQUE Constraint The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns. A PRIMARY KEY constraint automatically has a UNIQUE constraint defined on it. Note that you 阅读全文

摘要： Reference: http://msdn.microsoft.com/en-us/library/system.collections.specialized.namevaluecollection(VS.80).aspx 阅读全文

摘要： Reference:http://www.cnblogs.com/yuliantao/archive/2010/12/04/1896461.html对象：一切事物皆对象。类：对对象进行的抽象。实例：类的一个具体实体。 方法重载：方法名相同但是参数类型或者个数不同的方法。 面向对象的三大特性：继承，封装，多态 继承：子类继承父类后具有父类的保护和公有的一些方法，属性等并且能扩充自己。对于父类的构造函数只能调用不能继承。当对象与对象的关系是is-a时候用继承，当关系式has-a我们应该用组合或者聚合（桥接模式）。 封装：一个类在其内部拥有自己的方法，字段完成一些操作而不需要其他类，内部变化对于外面 阅读全文

摘要： .NET Framework 4 The System.Collections namespaces contain types that define various standard, specialized, and generic collection objects.Namespaces NamespaceDescriptionSystem.Collections The System.... 阅读全文

摘要： http://blogs.msdn.com/b/rahulso/archive/2006/08/29/string-concatenation-vs-string-builder-_2d00_-the-performance-hit_2100_-see-it-to-believe-it-_3a00_o_2900_.aspx 阅读全文

摘要： Reference: http://msdn.microsoft.com/en-us/library/8627sbea(v=VS.71).aspx 阅读全文

摘要： Reference: http://msdn.microsoft.com/en-us/library/wa80x488(VS.80).aspxIt is possible to split the definition of a class or a struct, or an interface over two or more source files. Each source file co... 阅读全文