PARSENAME is an SQL Server function used for working with linked servers and replication. It is also a handy addition to your TSQL toolkit when writing queries involving delimited data. This article covers the standard usage of PARSENAME as well as some handy tricks from a real world scenario.
Other News
Oracle: Preventing Corruption Before it’s Too Late – Part 2
(Marin Komadina) One block is soft corrupted when a block format is different from the Oracle default block format. Oracle soft data corruption (logical, software) is usually detected while reading some data from the disk to the database buffer cache. In the buffer cache, Oracle kernel investigate b
Building a House of Standards
(Brian Travis and Mae Ozkan) The main goals of web services are three-fold: –Get programs talking to each other, because we want to leverage the existing technology. –Be cheap, compact and scalable for all parties, because we want to have web services everywhere, providing services to everyon
INF: Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2
This article provides a sample SQL script for creating a linked server to DB2 using sp_addlinkedserver, and issues a few queries to illustrate the Distributed Query Processing (DQP) using DB2OLEDB, the Microsoft OLE DB provider for DB2. Please refer to the following article in the Microsoft Knowledg
Daydream Software plays to win with DB2
Whether you are flying your air-car through Cairo trying to pick up different colored balls faster than your opponent can, or racing a ski mobile over picturesque snowscapes, vying for video game dominance can be tough. Still, it’s nowhere near as intense as the rivalry among the video game companie
Integrate xmlspy 2004 Into VS.NET
(Dan Wahlin) Altova’s xmlspy has been one of the top XML editors for several years due to its support for XML document editing, schema design and validation, XSLT editing and debugging, and WSDL/SOAP capabilities. I’ve been a fan of xmlspy, but have often wished there were a way to integrate it
Oracle SQL tricks Part 1
Here are some useful SQL tricks, tested on an Oracle database. The tips include information on derived tables, locking, working with random numbers, and more.
External Tables in Oracle 9i
(Ajay Gursahani) This article gives a brief understanding about External tables. External Tables are defined as tables that do not reside in the database, and can be in any format for which an access driver is provided. This external table definition can be thought of as a view that allows running a
The Downside of Oracle CRM
(Erika Morphy) In the first article in this two-part series, we took a look at what analysts and customers have identified as PeopleSoft CRM’s greatest weaknesses — a list that runs the gamut from poor navigation to a confusing approach to the company’s CRM philosophy. Now it is Oracle’s turn t
Walkthrough: Accessing an XML Web Service Using Managed Extensions for C++
The following walkthrough describes the process for accessing an XML Web service from an application created using the Managed Extensions for C++. During the course of this walkthrough, you will accomplish the following activities: –Create a client application using the Console Application