(Robert Vieira) Scalar functions are not much different from stored procedures. Indeed, for the most part, they have the very same differences that the T-SQL versions.
Other News
Studying design patterns in VB.NET
(David M. Simmonds) Design Patterns in VB.NET is specifically designed to help Software Architects and Programmers to take advantage of GoF design patterns so that they can build software which is flexible and easy to maintain. You will find that application of the concepts which you learn in this s
Sub-templates and More with Oracle HTML DB
(Lawrence Linnemeyer and Bradley Brown) In this third part of a three-part article covering Oracle HTML DB, you’ll learn about sub-template definitions and more.
11i: Encrypted Password String Disclosure
Integrigy has released an advisory regarding an undisclosed security vulnerability in Oracle Applications 11i that may allow an unauthenticated, internal attacker to obtain Oracle Applications’ user account encrypted password strings, which in turn can be decrypted using previously published informa
CASE Function in SQL Server 2005 – part III
(Muthusamy Anantha Kumar) In Part I and Part II of this series, we have illustrated how to use simple case expressions in queries. In this installment, I am going to illustrate how to use case functions in clauses such as group by.
Visual Basic 6.0 – Exporting a DataReport to Microsoft Word
(John D.) In this article we’ll create a simple database in Microsoft Access and then create a user interface in Visual Basic 6.0.
Inserting a New Row in GridView
(Bipin Joshi) Many months back I wrote an article that explained a trick that allows you to add a new row to DataGrid. Just like DataGrid control the new GridView control doesn’t allow you to add new rows. Developers often use the following techniques to add new rows in such case: –They place a
XML Data Binding using Data Templates in XAML
(Doug Cook) Avalon provides a number of conveniences in terms of accessing and binding external data sources. This tutorial shows how you can bind and display XML data using a data template in XAML. This technique is also known as creating an XML data island.
Simplify Ajax development with jQuery
(Jesse Skinner) jQuery is a JavaScript library that helps simplify your JavaScript and Asynchronous JavaScript + XML (Ajax) programming. Unlike similar JavaScript libraries, jQuery has a unique philosophy that allows you to express common complex code succinctly. Learn about the jQuery philosophy, d
Using the New MySQL Query Profiler
(Robin Schumacher) One of the great things about MySQL is the superior innovation model that’s used to deliver database server software. Rather than relying solely on internal engineers who create and maintain a piece of software (as in a traditional software company), MySQL partners with the millio