ou might expect all SQL Server’s clauses to support a column alias. As reasonable as that assumption seems, SQL Server can’t honor a column alias in that way. If you
hether you develop custom database solutions or administer existing databases, you know that deleting records is a common task that’s easy to automate?most of the time. However, deleting all the
he performance of queries in applications is critical. You usually can gain manifold performance improvements by just improving query efficiency, and with IT budgets being squeezed, getting the maximum performance
If you’ve tried to back up a database in SQL Server 2008 and then restore it into SQL Server 2005, you know that the database backups are not backward compatible.
equential values can represent a lot in a database. Sometimes they uniquely identify records (as primary key values). Often they’re part of the natural data, such as a purchase order
hile many technologies promise to put features of desktop applications on the web, Adobe AIR brings web development to the desktop. Adobe AIR is a cross-platform runtime environment that allows
atrices are very useful mathematical objects that science and technology professionals use to describe real-life scenarios and build abstract models for those scenarios. You will find matrices used in economics
n an ideal world, all software and database systems would have clear documentation that is always up to date. In the real world, however, documentation usually is either non-existent or
ount yourself lucky if the data you need is always in the database you happen to be using. Most of us must retrieve data from all kinds of sources, and