Consider the following scenario: • In Microsoft SQL Server 2000, you execute a single query, or you execute multiple concurrent queries. • Each query returns several levels of nested derived tables. • Each derived table contains aggregations.
Author: SSWUG Research
Develop a customized wrapper for WebSphere Information Integrator
(Hai feng Li and Art Kaufmann) Many enterprises have a requirement to integrate heterogeneous data. Data may be stored in different brands of relational data management systems (RDBMSs), nonrelational servers, and specialized application systems.
Retrieving a Single Value from a Database
(Nathan Broslawsky) This PHP function pulls a single field from a single record in the database once the MySQL connection has already been established.
Creating a SharePoint Lists Report Using Crystal Reports with Web Services
(Eric Landes) SharePoint Windows SharePoint Service (WSS) has become well known in the corporate world. Many corporations are putting lots of data in department SharePoint sites. Some companies even use it as a basis for their custom applications. Utilizing web parts and the SharePoint lists, one
Add Custom Properties to a PropertyGrid
(Danilo Corallo) For my last project, I looked at the PropertyGrid control that has a very nice look and feel. Immediately, I noticed how difficult it was to use it. Looking over the Internet, I found lots of people wishing for something easier to use, like the TreeView or the ListView. So I started
An Introduction to ADF Best Practices
Oracle is leading the way in opening up the enterprise Java platform to both the 4GL and Java development audience through the productive and declarative environment of Oracle JDeveloper and Oracle ADF (Application Development Framework). Declarative business logic, visual page flow modeling and WYS
Leverage MySQL skills to learn DB2 Express, Part 3: DB2 versus MySQL graphical user interface
(Allan Tham) If you’re in the process of learning to use DB2 Express, chances are you’ve had experience with another database already, such as MySQL. This article serves as a skills transfer for existing MySQL database administrators to learn about IBM DB2 Express-C GUI administration. IBM DB2 Expre
Explorer ComboBox and ListView in VB.NET
(Calum McLellan) This article is an extension of Jim Parsells’ article “An All VB.NET Explorer Tree Control with ImageList Management”. I have added two main classes to Jim’s ExpTreeLib assembly – ExpCombo and ExpList. The ExpList directly inherits from ListView, and is partially based on the ListVi
Scripts and Transactions in Transact-SQL
(Dejan Sunderic) A script is usually defined as a collection of Transact-SQL statements (in one or more batches) in the form of an external file. Client tools, such as Management Studio and SQLCMD, usually have support for managing script files.
Generating View from MySQL to Simulate the Model-View-Controller Schema in PHP
(Alejandro Gervasio) Are you a curious PHP developer, wanting to learn how to simulate a basic Model-View-Controller schema with PHP? Then, look no further, because you’re in the right place. Welcome to the final part of the series “Simulating the Model-View-Controller Schema in PHP.” In three tutor