by Susan Sales Harkins – By using conditional compilation constants that control SQL statement generation, you can target both Jet and SQL Server, deliver applications to either platform, and reduce conversion time.
Other News
Google SVG Search I
In the next couple of installments we will make use of our previously acquired knowledge on the Google Web Services API and SVG in order to produce a CGI that graphically presents the search engine results returned by Google.
Ejen: Java/XML/XSLT-based code-generation
F. Wolff has released the final 1.0 version of Ejen, a Java/XML/XSLT system (currently implemented as an Ant task) designed to facilitate the creation of code generators.
Interactive Microsoft SQL Server & XML Online Tutorial
Written by: Scott Klein – This tutorial will introduce you to using XML with Microsoft SQL Server 2000™ and guide you through the concepts and techniques of how to read and write data using XML with Microsoft SQL Server 2000™. You will learn the various methods used and see how powerful and flexible
Oracle Data Provider for .NET
The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment. Unlike OLE DB .NET and ODBC .NET, ODP.NET is a native driver and does not use a data access bridge, which can reduce performance.
In the Picture
By Itzik Ben-Gan – Test your T-SQL skills (and create cool wallpaper) by creating code that randomly generates abstract patterns to certain specifications.
Creating a view between servers
Question to Jorge Cano – I have two MS SQL Servers 2000 on two machines. Is there a way I can create a view table in ServerA, which would look at ServerB, using a ServerA user, who does not exists in ServerB. Check out the answer! (R)
Define Your Own Functions in SQL Server 2000
SQL Server 2000 is the first version of the DBMS to enable SQL programmers to write their own functions. SQL Server Pro Joe Lax explains the three ways to write a user-defined function in SQL Server 2000.
Web Services at Work: Google Web APIs
A lot of hype is buzzing around Web Services these days. New acronyms are appearing every day and protocols and tools are implemented at break-neck speed; but not many real applications are publicly available up to now.Search engine Google makes the leap now and offers the Google Web APIs in
POSTing Form Data to a Web Page
By Bruce Johnson – Being able to post data to a web page from within a Visual Basic application can be quite handy. Even better when you can 'see' the response and process it automatically. Fortunately, there are at least two different techniques to achieve this goal. The best one depends on