(Amit Zhankar) This tip selects a column from a table, weeds out the numeric characters, and returns the alphabetical characters.
Other News
Mastering DataBinding
(Karl Seguin) Questions regarding databinding, in one form or another, are probably the most asked in the ASP.NET newsgroups. It’s clear everyone loves the idea of databinding but that more advanced functionality, such as event handling, conditional formatting and fine-tuning, aren’t straightforward
Extensibility, XML Vocabularies, and XML Schema
(David Orchard) XML is designed for the creation of languages based upon self-describing markup. The inevitable evolution of these languages — by adding, deleting, and changing parts — is called versioning. To make versioning work in practice is one of the most difficult problems in computing, wit
Local Data Model for .NET Database Application
(Wiktor Zychla) There are many different methodologies of the database programming. In fact, the one universal approach simply does not exist. A professional developer should not be deceived by some common concepts that are usable in typical situations but can be painful in a specific context. A
Get Into Index Structures
(Kalen Delaney) In my July 2001 column, “Are You in Tune?” (InstantDoc ID 21038), which began a series about query tuning, I mentioned that one of the best ways to ensure that your queries are running as fast as possible is to check that your tables are properly indexed. However, I didn’t discuss in
End-to-end Information Integration Key to On Demand Vision
This article is a Q & A with industry leader Jeanette Horan, Vice President, Worldwide Information Management Development; General Manager, IBM Silicon Valley Laboratory.
.NET Common Language Runtime (CLR) Tutorial
(Craig Andera) Microsoft’s .NET is a broad family of products representing the company’s next generation of services, software, and development tools. At the core of the .NET strategy lives the Common Language Runtime. The CLR is a platform for software development that provides services by cons
Using XSLT and .NET to Manipulate XML Files
(Cynthia Carolina) This article provides an introduction to the XML Stylesheet Transformations.XSLT is defined as a language for transforming source XML documents into another document formats using XML Path Language (XPath) as a query language.
Oracle Tip: Call multiple trigger bodies with a single trigger
(Scott Stephens) As applications become more and more complex, supporting business rules with triggers becomes more difficult. Triggers are useful for a wide range of applications, such as auditing, complex data validation, snapshots and data generation.
SQL Query Performance Tuning (Sample Chapter)
(Sajal Dam) Performance tuning is an important part of today’s database applications. Very often, large savings in both time and money can be achieved with proper performance tuning. The beauty of performance tuning is that, in many cases, a small change to an index or a SQL query can result in a f