Away From: Navigationless Database XML

All DevX newsletters are now sent from the domain "internet.com." Please use this domain name (not the entire "from" address, which varies) when configuring e-mail or spam filter rules, if you use them.

September 24, 2008
Volume 10 No. 9

www.devx.com

FEATURES | DISCUSSIONS | SUBSCRIBE

MS Access Can Handle Millisecond Time Values—Really
by Susan Sales Harkins and Gustav Brock
MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.

Navigationless Database XML: Hierarchical Data Processing
by Michael M. David
Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.

The Baker's Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
by Kevin S. Goff
SQL Server 2008 gets new developer features, and SQL Server 2008 Reporting Services gets a facelift and new architecture that no longer requires Internet Information Services.

Using PHP's MDB2_Schema, an XML-Based Database Schema Manager
by Octavia Andreea Anghel
MDB2_Schema lets you create and alter database schemas in an RDBMS-independent manner.

New in the DevX Forums

Stored Procedure Where I Can Pass an Undefined Number of Conditions	SQL 2005 Server Not Connecting
SQL Query with Full Text Engine in SQL 2005	Stored Proc that Creates a New Database
Locking the Database	Database Inserts
Change Field Names in Table	Generate XML Schema from SQL Server 2005
SSIS Flat File Import	Check If an Item in One Table Exists in Another
Equivalent Crystal Reports Function to rpad in PL/SQL?	Search Button in Access Not Working
Cannot Create Excel File with Field VARCHAR(8000)	Bulk Insert into SQL Database Using XML File
PhpMyAdmin Issue	Update Only Changes Made in SQL Table to Oracle Table
SSIS Using SharePoint Source

Whitepaper: Writing Good Use Cases
Writing good use cases is more of an art than a science. This paper helps readers develop use cases that more clearly communicate their detailed information to a diverse audience to effectively support the goal of creating successful software and systems development projects.

SQL Server 2008 Express: The Free Database from Microsoft
Don't dismiss Microsoft's SQL Server 2008 Express so quickly, simply because it's free. In the right circumstances it could be the no-cost answer to your database needs.

Tutorial: Learning PHP
If you're a programmer who wants to learn how to use PHP to build web-based applications, start here. Begin with the most basic PHP script, end up working with databases and streaming from the file system. In this part, we look at the basics of building a PHP script, including syntax, HTML forms, and database connections.

HOW TO CONTACT US
To contact us, please e-mail us via the form here. Please do not reply to this message; it was sent by an automated mailer.

REACH THOUSANDS OF DEVELOPERS AND IT PROFESSIONALS
To sponsor this newsletter or for more information about advertising opportunities, go to DevX.net.