(Michael Otey and Denielle Otey) In this article, you will learn how to use the OracleCommand object to execute SQL statements and stored procedures on an Oracle 9i database.
Other News
What’s New in Beta 2: Web Parts Revisited
(Jesse Liberty) I’ve been working with Whidbey (.NET 2005) for a little over a year. During that time, I’ve come to have enormous respect for the engineers at Microsoft, and I do believe that .NET 2005 (2.0) is a great improvement over 1.x. That said, the beta has had a bit of a hard time settling d
Seven Microsoft Application Blocks in One Neat Little Package
(Klaus Aschenbrenner) The problem with developing enterprise applications is you have to reinvent the wheel for each key area, such as configuration, database access, or security. Microsoft has addressed this problem in the past by providing application building blocks. However, one of the biggest p
Use Lifetime Value Data Mart to Drive Analytic Efficiency
(Amoy X. Yang) Customer lifetime value (LTV) can be quickly computed if all the required data is readily available. However, data tracking and data mining could be the biggest obstacle that hampers most direct marketers. There is little, if any, discussion on data preparation for LTV analysis. Build
Now Solutions Brings HR App to DB2
(Alex Woodie) Companies can now run the database portion of Now Solutions human resources and payroll software on IBM DB2, including DB2/400, the company announced last week. Now Solutions’ emPath software provides an array of capabilities for tracking employee hours and benefits, and now supports a
Open-source LAMP a beacon to developers
(Martin LaMonica) The so-called LAMP stack of open-source software–which includes the Linux operating system, Apache Web server, MySQL database and scripting languages PHP, Perl or Python–is pushing its way into mainstream corporate computing.
Swap Words in a String
(Chacravarthi Ramasami) This query swaps two words of a string (when declared and defined as a bind variable).
Relieving the Burden
(Bernard Chester) Email, enterprise resource planning (ERP) software, and accounting packages are essential tools for many businesses. These applications accumulate vast amounts of important information; however, the sheer volume of all that information can eventually degrade application performance
A Look at Microsoft’s ‘Web Data Administrator’
(John Peterson) Do you spend part of your day administering a remote SQL Server? If so, has Microsoft’s got the tool for you. Introducing Microsoft’s Web Data Administrator…
SQL Server DO’s and DONT’s
(Daniel Turini) So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don’t know what to do next. Or maybe you simply want to know of some design guidelines for solutions usi