About DatabasesDatabasesUsing TRYCATCH to Handle SQL Server Errors- June 24, 2008 The TRYCATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and...http://databases.about.com/b/2008/06/24/using-trycatch-to-handle-sql-server-errors.htm Too Many Reports and Queries in Access- June 22, 2008 In a recent forum posting, Emilia wrote: "I seem to have too many reports and queries. For example, I have several reports each slightly different with its own query....http://databases.about.com/b/2008/06/22/too-many-reports-and-queries-in-access.htm Using the Ribbon in Access 2007- June 19, 2008 If youre switching to Microsoft Access 2007 from an earlier version, youre bound to immediately notice some major changes in the user interface. Microsoft modeled the Access 2007 look-and-feel after...http://databases.about.com/b/2008/06/19/using-the-ribbon-in-access-2007.htm Free Databases: Too Good to be True- June 17, 2008 In a recent forum posting, Dan wrote: "It seems a lot of the information I've come across says that server database can run an expensive bill. But, I was able to...http://databases.about.com/b/2008/06/17/free-databases-too-good-to-be-true.htm SQL Server 2008 Release Candidate 0 (RC0) is Here!- June 15, 2008 This week, Microsoft released SQL Server 2008 RC0. This major step in the development of the new product indicates that we're not far away from seeing the official release...http://databases.about.com/b/2008/06/15/sql-server-2008-release-candidate-0-rc0-is-here.ht... SQL Server Agent Alerts- June 12, 2008 SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center. Read...http://databases.about.com/b/2008/06/12/sql-server-agent-alerts.htm Additions to Access Function Library: Hex(), Hour() and IIf()- June 10, 2008 We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: Hex() Hour() IIf() ...http://databases.about.com/b/2008/06/10/additions-to-access-function-library-hex-hour-and-... Access 2007 Compatibility Issues- June 8, 2008 In a recent forum posting, Sue Hopkins wrote: "I created a database using Access 2003. When a user opened it with Access 2007, most of the switchboard was not visible....http://databases.about.com/b/2008/06/08/access-2007-compatibility-issues.htm Introduction to MySQL- June 5, 2008 Database professionals around the world are heralding the release of MySQL 5, just in time for the holiday season! This major release of the popular open-source database packs in quite...http://databases.about.com/b/2008/06/05/introduction-to-mysql-8.htm Forms in Access Databases- June 3, 2008 In a recent forum posting, Priya_23 wrote: "I'm pretty new to using Access. I have just created a database in access by importing the data on my excel spreadsheet, and now...http://databases.about.com/b/2008/06/03/forms-in-access-databases.htm |