SQL Server 2005: Intro to XQuery
Where I currently work we
are still using SQL Server 2000 in production! Recently I needed
to produce a hierarchical report with data from numerous joins.
The process of taking data from SQL 2000 via FOR XML AUTO and then
transforming it with XSLT was painfully slow. It took well over a
day of dev time to produce a framework that would allow easier
changes in the future. If we could move to SQL 2005 then we could
take advantage of XQuery as outlined in this article
SQL
Server 2005: Intro to XQuery. Using XQuery I think the same
results could have been achieved in less than an hour.
banner.jpg
http://tforster.files.wordpress.com/2007/02/banner.jpg
Looking for C# IsNumeric()? Try char.IsNumber()
Funny how sometimes the
simplest functions are the hardest to find. The other day I needed
to test a value to see if it wa numeric. I stupidly assumed that I
could write something like string s = "123";
if
(isNumeric(s)) { //do stuff } And quickly realized this
wasn't going to work when VisualStudio threw a compile time error.
After (too) much digging I discovered that the function exists and
it is actually a method of the char type. Therefore
string s
= "123"; if(char.IsNumber(s)) { //do stuff
}
how to iterate a dojo dictionary
var iter =
myDict.getIterator(); while (!iter.atEnd()) { var dictEntry =
iter.get(); // key is available as dictEntry.key // value is
available as dictEntry.value }
O'Reilly -- What Is Web 2.0
Tim O'Reilly (of O'Reilly
books) presents a comprehensive definition of Web 2.0. This would
be a great companion article to the What Is Web 2.0 video that has
been floating around on YouTube recently.
O'Reilly -- What Is Web 2.0
Making Javascript DOM a Piece of Cake with the graft() Function
An interesting article
that introduces a useful function called graft(). graft() takes a
JSON string defining a serious of DOM elements and returns a DOM
fragment that can be inserted into the document element. Now I
haven't tried the code in this article yet and some of the comments
indicate that there maybe some truncation so be forewarned.
Making Javascript DOM a Piece of Cake with the graft()
Function