In Oracle/PLSQL, the substr functions allows you to extract a substring from a string.
Author: SSWUG Research
Using XML To Send Multiple Rows At Once Into A Stored Procedure
(Travis Laborde) From time to time, people ask the question “How can I insert many records at once into SQL Server?” The purpose of this quick article is to describe that process in very basic details. I’ll give a very simple example, so that you can then take it from there.
Using SQL Server’s XML Support (Sample Chapter)
(Ken Henderson) As we saw in the earlier discussions of updategrams and OPENXML, inserting XML data into a SQL Server database is relatively easy. However, both of these methods of loading data have one serious drawback: They’re not suitable for loading large amounts of data. In the same way that us
Business Intelligence Solutions with HP Integrity Servers and Microsoft SQL Server 2005
This HP white paper describes the evolution of data warehousing systems and explains how standards-based, object-oriented programming has improved the newest generation of Business Intelligence (BI) software. The paper outlines key differences between components-based and integrated approaches to BI
IBM DB2 Enterprise 9 performance with POWER5+ and AIX 5L multipage support
(Sunil Kamath and Punit Shah) For a variety of reasons, most modern operating systems run programs in virtual address space. The virtual address offers many advantages, including flexibility, isolation, transportability, the ability to access more memory than the amount of physical memory, and to so
Developing with Apache Derby — Hitting the Trifecta: Database development with Apache Derby, Part 4
(Robert Brunner) The previous article in this series, Developing with Apache Derby — Hitting the Trifecta: Database development with Apache Derby, Part 3: Running scripts and inserting data, ended by running a script that inserted ten rows and then displayed these rows for validation. That article
Using Excel to analyze MySQL data
(W. Jason Gilmore) Even in this age of powerful reporting tools like Crystal Reports and flexible customer management applications like SugarCRM, Microsoft Excel remains the most commonly used tool for analyzing information such as contact demographics, sales statistics and revenue projections. This
SQL Server 2005 Integration Services – Checkpoints – Part 26
(Marcin Policht) In our previous article of this series, we discussed transactional support in SQL Server 2005 Integration Services. Such support is critical in order to ensure that arbitrarily designated Control Flow tasks are executed as a single logical unit, which either completes successfully o
Trace Your Application
(Abey George) Akin to response.write of classic asp, Asp.net introduced a new simple debugging feature called as Tracing (I am certain that most of you guys might have used it).
Enterprise Library Security Block
(Brian Mains) The Enterprise Library Security Block is a means to authorize users to perform certain actions based on a set of rules. The rules approach creates a programmatic way of authorizing users at a function level and reduces the amount of in-line code that does the same work.