When handling a project with hundreds of tables, it takes some time to understand the flows. Learn how to create a simple tool for Visualizing database tables and relations.
Latest Database Articles - Page 6
There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them specifically, Common Table Expressions (CTE), because they often come in handy.
Table-valued user-defined functions (UDFs) are functionally similar to views but structurally similar to stored procedures, giving them all the important features of views and stored procedures and some additional functionality that they lack.
Learn to implement and OLE and IDispatch interface to access basic Excel functions from a C++ application.
In ASP.NET 2.0, you can customize the session state store as per your requirement. Explore one of the scalable and reliable approaches for storing session variables—SQL Server.
Learn how to process XML documents' content with the Microsoft COM implementation of Simple API for XML (SAX).
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
It's essential to know the differences in these libraries and use them correctly. This brief tutorial will guide you.
With facilities to search, copy, extract segments, and more, the array class can handle pretty much any task you need to perform with ease.
Enhance your development skills and make your users' lives easier.
If you have written solid code, you have accomplished one half of the objective. Solid code is the protagonist, or hero, of our story, but testing is the more sedate side kick that often saves the day after the hubris of the hero has almost certainly lead to calamity.