Geeks With Blogs
BizTalk Blog by Chris Han System Design for Enterprise Agility,
October 2007 Entries
A little after lunch game for T-SQL develoepr - how confident are you with your code?
Here is how you should play it: 1. Make sure your have both a SQL 2000 with latest sp and a SQL 2005 database 2. guess the result of the two 'print' command in the script below, write down the last character in the string on your mind 3. Run the script below in SQL 2000 4. Change the 3999 to 3998 and run it again on SQL 2000 5. Change the 3998 back to 3999 and run it on SQL 2005 ---------------------------... declare @n varchar(4000) set @n = replicate(N'z',3999)+N'i' print @n set @n=replace(@n, ......

Posted On Tuesday, October 23, 2007 11:55 AM

You think it's a bug? It's a feature!
It used to be a joke when there was some software design flaws caught at the test phase. It is amazing to see that the joke presents a truth by reading this new from MSNBC http://www.msnbc.msn.com/id... If you put the hybrid car as an architect, one of the most important questions you should have asked yourself as an architect is 'how it will interact with the environment it resides?' You thought the noise of the gasoline car is something unwanted? Think again. It is really depends on which ......

Posted On Thursday, October 4, 2007 1:35 PM

Copyright © Chris Han | Powered by: GeeksWithBlogs.net