RAISERROR is used to return messages back to applications using the same format as a system error or warning message generated by the SQL Server Database Engine.
Author: SSWUG Research
Enhancing SQL Server Functionality with Functions
(Baya Pavliashvili) In this new series of articles on functions, I will discuss built-in and user-defined functions in SQL Server 2000. Built-in functions provide a way to check system information and metadata or enhance the functionality of your code by manipulating the data in system and user data
IBM DB2 Universal Database and the Java Developer? Absolutely! – Part 4
(Paul C. Zikopoulos) In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (Rational AD) product to create and work with IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows database connections. Part
Size, Language and Reuse
(Douglas Putnam) Over the last two decades, there has been a dramatic downturn in developed project size. Organizations appear to be breaking larger systems into smaller, more manageable pieces. The benefits are apparent in the decline of mammoth, out-of-control software projects, but there may well
.Net Memory Management Rules: Part 1
(ayzec) .Net objects that are allocated onto the managed heap will be automatically de-allocated by the CLR. As you are building your applications, you are correct to assume that the managed heap will take care of itself without your direct intervention. In fact, the golden rule of .Net memory manag
Multithreading in Visual Basic .NET
(John Spano) Multithreading, a very powerful technique, is essential for modern software development. Software users expect to work with a responsive program that they do not have to wait on, which is a very reasonable demand with the processor speeds that are currently available. Enter multithread
Object-Oriented database design with the DatabaseObjects library
(Toby Wicks) The DatabaseObjects library was designed to aid in creating object-oriented database systems quickly and easily. It achieves this with a set of generic functions and interfaces that automatically generate all of the necessary SQL statements to load, save, search, delete and enumerate a
Fast Text Processing in SQL Server
(Alex Kozak) Processing text or long strings in SQL has never been an easy task. SQL is a powerful language for performing fast operations on data sets, but when it comes to processing text or long strings, it’s usually reduced to a prosaic procedural language. This article shows a few techniques fo
Oracle Database Vault
Oracle Database Vault provides a solution to help customers address the most difficult security problems remaining today, protecting against the insider threat and meeting regulatory compliance requirements. Oracle Database Vault keeps the DBA from viewing application data, a top concern for custome
Microformats in Context
(Uche Ogbuji) There has been a lot of discussion in XML circles as to how far the extensibility revolution promised by XML can take (or has taken) us. Is XML really a tool for creating specialized languages so that information can be expressed in the most natural formats practical? Or is it just a w