(Erland Sommarskog) Questions you often see in newsgroups about MS SQL Server are: How can I use the result set from one stored procedure in another or How can I use the result set from a stored procedure in a SELECT statement? This article presents different answers to these questions, and I als
Other News
Redistributing DTS with your program
(Darren Green) If you’ve written a program that utilises DTS then you will need to distribute the DTS files along with your new program. Programs such as the Visual Studio Package and Deployment Wizard will not automatically include all of the files required. The definitive reference for redistribut
XQuery Tutorial — Free
In this XQuery tutorial you will learn what XQuery is. You will learn how to use XQuery to extract data from your XML documents.
Isolation level UR the beauty and the beast in one
(Klass Brant) DB2 does uses locking to protect you from incorrect or invalid data. The locking will protect you both from logical and physical corrupt data. The isolation level which can be set either at bind time or at each individual SQL statement enhances the way DB2 will deal with the locking. T
Understanding User Defined Functions (UDF) in SQL Server 2000
(Vinod Kumar) This topic as such is new to SQL Server terms even though they have existed in the many other programming languages before. In this article I would walk you through some of the most common usage of UDFs in SQL Server 2000 context. Note that some of the tips and tricks used in this arti
Crafting Service Providers: Creating a Versatile Reporting Package
(Steven Feuerstein) In the previous six articles in this series, I’ve covered all the aspects of Codecheck related to extracting and analyzing argument information, but I haven’t yet touched on this small-but-crucial related aspect: reporting the results. In this article, I’ll step through the proce
The TAG’s Town Hall
(Kendall Grant Clark) As a relatively new resident of the East Coast, living two hours south of Philadelphia, and as someone who finds Philly one of the most interesting, most American of American cities, I didn’t hesitate when Edd Dumbill suggested I join him at IDEAlliance’s XML Conference 2003 at
Plans + DBRMS + Packages + Collections + Versions = Confusion
(Bonnie Baker) No matter how long programmers have worked with DB2 for z/OS and OS/390, they still ask me to tell them the difference between a plan and a package — and what in the heck a collection is. I planned to write a column on this topic so I could just point them to DB2 Magazine, Quarter 4,
Coordinate Your DTS Tasks, Part I:
(Drew Georgopulos) The version of DTS in SQL Server 2000 provides a bundle of pre-packaged tasks. Most are dedicated to moving data, but some are specific to SQL Server maintenance. The data tasks facilitate moving information between database servers (not limited to SQL Server), or moving other fil
Using the DB2 Command Line Interface
(M. H. Scholl, Jens Teubner and Svetlana Vinnik) In order to use the DB2 command line interface, you need to extend your shell’s search path and set some environment variables. The simplest way to do this is to source the script I provided you. Add this line to the ¯le .bashrc.username in your hom