http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx Programming Articles en-US Tue, 06 Jan 2009 05:32:07 GMT Tue, 06 Jan 2009 05:32:07 GMT Cuyahoga Website Framework 60 http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx/343 I can't find the exact syntax for adding the IDENTITY property to an existing column. I checked the ALTER TABLE syntax, but it describes only adding a new column that includes the IDENTITY property. How can I add this property to an existing column? FengLiN Tue, 04 Dec 2007 09:58:03 GMT SQL Server http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx/295 SQL Server provides a mechanism for returning different values in a SELECT clause based on Boolean conditions: the CASE statement. This statement resembles Visual Basics Select Case statement. The SQL CASE statement has WHEN, THEN, and ELSE clauses... FengLiN Thu, 29 Nov 2007 14:09:16 GMT SQL Server http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx/95 SQL Server DO's and DON'Ts So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don't know what to do next. Or... FengLiN Mon, 22 Oct 2007 03:59:14 GMT SQL Server http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx/94 Learning .NET Regular Expressions with Expresso Did you ever wonder what Regular Expressions are all about and want to gain a basic understanding quickly? My goal is to get you up and running with a basic understanding of regular expressions... FengLiN Mon, 22 Oct 2007 03:53:05 GMT Regular Expressions http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx/28 What to avoid In-line CSS Absolute font sizes Single quotation marks around paths for images CSS hacks Redeclaring inherited values Applying padding/borders and a fixed width to an element.... FengLiN Tue, 16 Oct 2007 03:05:08 GMT CSS http://www.huachaojune.com/23/section-Programming-Articles/Programming-Articles.aspx/27 If a method can be static, declare it static. Speed improvement is by a factor of 4. echo is faster than print. Set the maxvalue for your for-loops before and not in the loop. Unset your variables to free memory, especially large... FengLiN Tue, 16 Oct 2007 03:03:00 GMT PHP