Other News

Community

Overcoming OpenXML hangups

By Rich Rollman – If you’re writing an application that uses XML as a data-interchange format, you need a way to extract the data from the XML document and store that data in your database. T-SQL’s OpenXML keyword is a convenient way to insert, delete, and update data in SQL Server 2000. OpenXML cre

Community

Hiding the Oracle password

By Rochus Mission – When you have more than one Oracle database, you may be required to supply the name of which database you want to log on to. If you are using SQL*PLus, for instance, you will need to provide three login parameters (username, password, and db_name) on the same line.