Travis Vandersypen
President
Travis Vandersypen is a Senior Software Developer at EPS Software Corporation, located in Houston, Texas.
He concentrates on consulting on and developing COM-based, distributed applications. He is an international author and speaker, co-author of the Fox Extension Classes, co-author of the Voodoo Web Controls, and 3-time Visual FoxPro Excellence Award Nominee.
He can be reached via email at: travis@eps-software.com.
Articles Authored
-
XML UpdateGrams in SQL Server
Last updated: Sunday, December 7, 2025
Published in: CODE Magazine: 2002 - January/February
In this article Travis Vandersypen explains how SQL Server 2000's XML UpdateGrams provide a cleaner, transactional way to insert, update, and delete data via XML posted to the SQL virtual directory, avoiding OPENXML and URL length limits; he details the UpdateGram structure (<sync>, <before>, <after>), implicit and explicit XDR mapping strategies, NULL and identity handling, concurrency considerations, and practical execution tips for using UpdateGrams to map XML to relational tables.
-
XPath Queries in SQL Server 2000
Last updated: Saturday, December 6, 2025
Published in: CODE Magazine: 2001 - Issue 1
In this article, Travis Vandersypen explains how XPath Queries combined with XML-Data Reduced (XDR) Schemas enable developers to access and query SQL Server 2000 data without needing detailed knowledge of SQL or database structure. By defining XML schemas that map database tables and relationships, developers can retrieve and manipulate XML-formatted data directly via URLs using familiar XPath syntax. This approach shifts complexity to DBAs, allowing schema changes without impacting application code, and facilitates more flexible, XML-based data access and integration in SQL Server 2000 environments.
-
Query XML from SQL Server 2000
Last updated: Friday, November 21, 2025
Published in: CODE Magazine: 2000 - Fall
In this article, Travis Vandersypen explains how Microsoft SQL Server 2000 introduces native XML support, allowing developers to query data directly in XML format using the `FOR XML` clause with options like AUTO, RAW, and EXPLICIT. He details the configuration steps for enabling XML support via IIS, demonstrates querying data through URL and Template queries, and shows how XSL stylesheets can transform XML output for various presentation needs. Vandersypen emphasizes that this built-in XML functionality simplifies data integration for distributed applications by eliminating the need for custom conversion routines, enabling developers to focus more on business logic.