Often perceived mainly as a query language, XQuery can actually be used to generate XML and HTML. Per Bothner provides a worked example, and compares XQuery with XSLT.
Author: SSWUG Research
XML for Web Developers – in 500 words or less!
Recently, Andrew Watt (author of the book Sams Teach Yourself XML in 10 Minutes) started an interesting discussion thread on XML-DEV mailing list. The topic was to describe XML in 500 words or less to an “ordinary” Web developer (who has no formal Computer Science training).
Validate XML Against Multiple Schemas
by Dan Wahlin – This sample application demonstrates how you can validate three different sections of an XML instance document against three different XML schemas, all within different target namespaces. The application leverages the XmlSchemaCollection class along with the XmlValidatingReader to pe
Display Session Information
by Jayant Kulkarni – Displaying session information is a regular task for a DBA. DBAs have been using information from v$session and v$process to find out relevant information about a process in order to kill a session, such as finding the UNIX id associated with the process, identifying more detail
Trimming a string in versions before 8i
By Keshav Chennakeshav – In many data manipulation and querying scenarios, you may need to trim a string. To do this in Oracle, LTRIM and RTRIM are available. Here is a utility function that combines the two. Note: this function is a standard feature of Oracle 8i and higher. So it will be of use for
Keeping Up with Web Releases
By Michael Otey – Microsoft offers a lot of functionality as free downloads, including the latest SQL Server 2000 XML functionality. If you ignore these updates, you’re leaving money on the table.
Retrieve an Identity Value
by Roman Rehak – Most objects in ADO.NET were designed to operate in a disconnected mode. The data is retrieved from the server and cached on the client in a DataSet or DataTable object. You make changes in the client application and use a DataAdapter to connect to the database and propagate the cha
Word wrapping with T-SQL
By Andrew Novick – Word wrapping isn’t the kind of task that is done in T-SQL very often. That’s a good thing. The SQL Server engine isn’t really the right location for formatting functions like wrapping. However, there are times when there isn’t a suitable front end that can perform the word wrappi
Case-Sensitive Comparisons
How can I program a case-sensitive comparison of a user-typed password on a case-insensitive SQL Server 7.0 instance?
SQL Server Hardware Resource Planning
by Robert H Chin – Planning on getting new SQL Server hardware, this article might provide some help.