(Haidong Ji) In my previous articles (Using xp_cmdshell, Using WMI, Using VBScript, Automate DTS Logging, among others), I talked about various technologies you can use to automate SQL Server management. Different situations call for different techniques. Many times, you may find yourself using a co
Author: SSWUG Research
A View to Automation
(Alex Glauberzon and Martin Wiseman) Think about the last time you had to update a table that contained a large number of columns. Now, imagine that the table is under construction and you’re responsible for adding or deleting columns or modifying columns’ data specifications. And, of course, this s
Cursors with SQL 2000 Part 1
(Don Schlichting) SQL languages are designed so groups of records, or sets, can be manipulated easily and quickly. The speed at which groups of data can be altered, updated and deleted, demonstrates why working with sets is the preferred method. A traditional programmatic database connection, us
Work with IBM DB2 UDB databases and SQL in Delphi for .NET
(Bob Swart) This article, a follow-up to the SQL DDL article, Using Delphi code to create/drop DB2 UDB database tables, focuses on the use of SQL queries to build simple and more complex SQL SELECT queries to end up with master-detail relations. The author also examines SQL joins in detail, covering
In XML: Using SQL to Link Below the Root – Part 1
(Michael M. David) SQL/XML integration is in a mess today. Every SQL vendor’s XML support is proprietary and still does not integrate seamlessly, fully, or satisfactorily. The current working standards solutions, XQuery (when used in SQL) and the SQL/XML Standard are very XML centric and do not inte
Fast Path to IBM DB2 Universal Database in a Visual Basic .NET Environment
This course provides training using Microsoft Visual Basic .NET as an add-in with DB2 UDB V8 on Linux, Unix, and Windows. Learn how to use the Microsoft Development Environment to create DB2 UDB database applications. Design applications to create database objects, populate tables, execute queries,
Excel Document Management with the Oracle iFS (Internet File System)
(Marin Komadina) There are several methods to load data from Excel to Oracle and vice versa. Some of the methods are widely used while others are complicated and very seldom used.
Component to access databases in the .NET environment
(Xiangyang Liu) An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.
Validating User Input – An Introduction
(Scott) Data validation is an important task in any application. Before accepting new information from a user, you need to make sure all the information is present in required fields, make sure all the dates have a valid format, make sure all the numbers in a form have a valid range, and all the oth
Resolving the Unknown: Building Custom XmlResolvers in the .NET Framework
(Mark Fussell) This article gets under the hood of the XmlResolver class in System.Xml and describes how to create your own implementations of XmlResolvers that allow you to retrieve XML documents from alternative data sources, such as embedded assembly resources or from a database using custom defi