(Gregory A. Larsen) If you need to make small changes to an existing database object, then you will need to do some impact assessment to determine what SQL Server Objects will be affected by your small change. So how do you identify those database objects that will be affected by a scheme change? Is
Author: SSWUG Research
The Active Record Pattern
(Jason E. Sweat) This article, the second of two parts, helps you use design patterns to better organize how your web application interacts with a database.
How do I pass the required parameters of a Stored Procedure in Crystal Reports?
(Jorge Luis Fernandez) This small tip shows how to pass the required parameters of a Stored Procedure in Crystal Reports.
The AJAX Year In Review
(Dion Hinchcliffe) Ajax has been the other big software story of 2005, along with Web 2.0. An optional ingredient to Web 2.0 software, Ajax has changed the perception of Web-based software as being horribly clunky, page-oriented, and boring when compared to native computer applications. Ajax descr
.NET Stored Procedure: Reading a Text File into an Oracle Table
(Jagadish Chaterjee) In this article, I shall introduce you to developing a .NET based CLR stored procedure, which can read a simple text file and transfer that information into an Oracle database using Visual Studio.NET.
Powering Windows
(David A. Kelly) Growth is good for business, but it can be difficult on the IT group. When the crunch comes, many IT administrators turn to two familiar faces: Oracle and Microsoft.
Understand Oracle 10g’s new multiset operators
(Scott Stephens) The Oracle 10g database release has a new set of Advanced Multiset support operators for SQL Server 2003, which you can use with nested tables in an Oracle database. This new SQL syntax provides powerful functionality that has been missing from nested tables since they were introduc
What’s Hard about XML Schema Constraints?
(Marcelo Arenas, Wenfei Fan and Leonid Libkin) Data description for XML usually comes in the form of a type specification (e.g., a DTD) together with integrity constraints. XML Schema allows one to mix DTD features with semantic information, such as keys and foreign keys. It was shown recently that
Using MySQL – Introducing SQL
(Keith Brown) This is the first in a series of MySQL workshops designed to introduce MySQL and SQL statements to a novice developer.
Exception Handling in Sql Server 2005
(Raymond Lewallen) SQL Server 2005 provides a new exception-handling mechanism in the form of TRY…CATCH. In current version of Sql Server you have to include GOTO statements, and check @@ERROR after every statement is executed to determine if an error had occurred at that particular point and term