This article demonstrates how to programmatically control bcp to generate text files. It uses dynamic SQL and xp_cmdshell to execute a call to bcp from within Query Analyzer.
Other News
Use XSLT to Merge XML Documents
(A. Russell Jones) XML documents excel at validating, extracting, storing, and transmitting hierarchical data, but as they become more common, the need to merge data stored in different XML documents increases as well. You can use XSLT to merge data from two or more XML documents into a single docum
Using PHP With XML (part 1)
By icarus Melonfire – The strange thing about XML, though, is that it's very hard to figure out where to start. It doesn't take long to figure out the basics of creating an XML file, or the rules for XML markup. However, that's where most novice developers hit a brick wall; XML documenta
New Encryption and Decryption drafts
The W3C released initial drafts of XML Encryption Syntax and Processing and Decryption Transform for XML Signature.
Getting Your Quotes Right In SQL For ASP
by Al Hetzel – It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these q
Project JXTA: An Open, Peer-to-Peer Collaboration Platform using Java and XML
Interest in peer-to-peer (P2P) technology is growing rapidly, as shown by the popularity of services such as Napster and Gnutella. Sun Microsystems started a project called JXTA to examine the potential of a generic P2P platform, which is described here.
W3C issues XML base, XML linking language
Douglas F. Gray – The World Wide Web Consortium (W3C) Wednesday announced the publication of two W3C recommendations regarding XML (extensible markup language), which are aimed at standardizing more features of the language.
Toolkit for NewsML
Reuters have released NewsML Toolkit v1.0, developed in conjunction with David Megginson, to assist in creating applications for the NewsML news publishing framework. The open source toolkit, licensed under the LGPL, is a set of Java classes that aid the accessing and manipulation of News
SQL Server Editions
SQL Server comes in more editions than any other Microsoft .NET Enterprise Server. In fact, SQL Server 2000 comes in no fewer than seven varieties. Here's a quick guide to the differences among the SQL Server 2000 editions. (If you aren't sure which edition of SQL Server you're using, yo
Introduction to Dynamic SQL (Part 2)
In a follow up to the Introduction to Dynamic SQL we take you through some of the tricks and pitfalls of this technique. We'll cover Create Table, sp_executesql, permissions, scope and more.