By Eli Robillard – The document assists users migrating from Microsoft Access to Microsoft SQL Server. Though written specifically for users of GenericDB, the process may be applied to any Access database. Of particular note are the instructions to convert a Random Autonumber field to one whi
Other News
Getting the last inserted sequence value
By Venkat Arikatla – This function will return the last generated sequence value for a given table. It will work both for Oracle 8i and 9i
SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB
OLEDBSQLXML.exe demonstrates how to create an ATL OLE DB client that extracts an XML Stream from a SQL 2000 Server using a SQL XML Query.
Multi-Level Collections in Oracle 9i
Steven Feuerstein and Bryn Llewellyn continue their series of articles on new Oracle 9i features with both simple and complex examples showing you how to work with multi-level collections.
Hitachi, Oracle Ally on Storage Technology
Hitachi and Oracle have announced they will strengthen an existing alliance, creating a partnership focused on improving integration of database management and information storage. Their first product will be a software library that enables administrators to more easily find and extract Oracle data
Interact with SQL Server’s Data and Procedure Cache
(Randy Dyess) Article which briefly discussed SQL Server’s data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
SQL Server Magazine University (SSMU) e-Learning Center
Our instructors make the difference between textbook talk and real-life practical applications! Click here for the details.
Trustworthy Computing Security Update
This market bulletin provides answers to frequently asked questions about the Slammer worm. It includes detailed information about which systems are susceptible to the virus, provides links to the latest security patches, and suggests proactive steps that customers can take to safeguard their system
Make Web Services More Flexible
by David Chappell and Tony Hong – RPC mechanisms limit Web services’ usefulness, but asynchronous messaging adds reliability and flexibility to data movement. See how JMS and SOAP provide effective data transport.
XSLT On Client Side
This article shows how to use XSLT on the client side to transform XML into HTML. More specifically, we’ll look at the following examples: