Database Development Zone

An Automated Solution for Migrating Database Structures

anaging the design and creation of database objects such as tables, stored procedures, and views is a fact of life for database developers. Because applications grow and change continually, additions and changes to database structures (or schemas) are a constant part of the development process. Developers generally create the requisite

The Time Has Come for the Decentralized Application Architecture

usiness applications today are stuck in a time warp. Web-based applications offer ubiquitous access, but the business application architecture many companies use is still locked into the decades old centralized mainframe model?a model where end-users often access a single instance of the application and almost always access a centralized corporate

Develop a Consistent Naming Convention for Your Database Objects

he sheer number of objects in a database makes keeping track of them difficult. Keeping track of objects dedicated to a particular table, such as constraints and column names, can be discerned by using sp_help @tablename or the information_schema views. The identification of other objects and their dependencies shared between

Book Excerpt: SQL: The Complete Reference, Second Edition

eaturing broad coverage of every aspect of this leading database language, SQL: The Complete Reference provides you with an overview of SQL?then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies?including XML, Web services, EJB,

Book Excerpt: Oracle9i XML Handbook

his insider’s resource, written by the Oracle XML Development Team, explains how to take full advantage of the Oracle XML Developer’s Kit (XDKs) and maximize Oracle9i’s XML-enabled features. Create and deploy cross-platform, transaction-based applications on Oracle9i with XML?the industry standard for describing data for e-business application integration and business-to-business exchanges.

Book Excerpt: Oracle9i The Complete Reference

hapter 21: Using SQL*Loader to?Load DataIn the scripts provided in Appendix A, a large number of insert commands are executed. In place of those inserts, you could create a file containing the data to be loaded and then use Oracle’s SQL*Loader utility to load the data. This chapter provides you

Use Globally Unique Identifiers in Access and SQL Server

Globally unique identifiers (GUIDs) distinguish hardware, software, and users. Originally, Microsoft designed the GUID value for use with ActiveX controls; Windows uses a 128-bit GUID to identify ActiveX controls. A 48-bit version generates an Ethernet adapter address. Because no two systems should have the same Ethernet adapter address, a GUID

Access SQLXML Technology from .NET Apps

With the release of the SQLXML Managed Classes, which Microsoft shipped with SQLXML in March of this year, developers now can access SQLXML technology (XML views, templates, XPath, XQuery) from .NET applications. This function enables .NET application developers to retrieve data from relational databases as if they were big XML

Make SQL Server Respond to an ORDER BY Clause

ometimes, how you present data is just as important as the data itself. One of the simplest presentation techniques is to sort the data in some meaningful way, but SQL Server Views don’t support the ORDER BY clause. In this article, you’ll learn how to sort the results of a

No more posts to show