A user-defined function returns results that are not correct for a query if all the following conditions are true: • The GROUP BY clause contains two or more references to the same user-defined function. • The calls to the user-defined function pass the same first parameter. • The user-d
Other News
Unified Database Toolkit – Scheduling
(Andre Vigneau) I have been working for a while in administering and developing for SQL Server, MSDE, even with the new SQL Server Express. I have put in place a resident database to store tools I use to perform administrative tasks and statistical collection tasks. I also have an automated system t
Developing A Login System With PHP And MySQL
(John L.) Most interactive websites nowadays would require a user to log in into the website’s system in order to provide a customized experience for the user. Once the user has logged in, the website will be able to provide a presentation that is tailored to the user’s preferences.
Oracle Ousts Its Own Execs
(Renee Boucher Ferguson) In the midst of swapping out executives at recently acquired PeopleSoft Inc., Oracle Corp. is also making some internal adjustments. The company quietly replaced two top executives last week, including Ron Wohl, executive vice president of application development, according
Using Synonyms with Informix XPS and DB2 UDB
Informix XPS and DB2 UDB support the concept of synonyms. This Technote discusses the use of synonyms with both databases.
Configuring Materialized Query Tables (MQT)
MQTs are a powerful way to improve performance and response time for complex queries, particularly those associated with analyzing large amounts of data. This Technote discusses the considerations and approaches for configuring MQTs appropriately.
Security Watch: New Worm Targets WINS Bug
(Larry J. Seltzer) The top threat this week is not a real-world threat yet, but Winxor.A portends a new wave of worms that use a bug in Windows servers to spread far and wide. See the Top Threat Section for details.
Describing Oracle Syntax
(Steve Callan) What do FORTRAN and Oracle have in common? The answer to this question is at the end of the article, so before we get there, allow me to use the study of mathematics as a model.
Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyzer
(Dina Fleet Berry) There are many times when using SQL Server 2000 Query Analyzer to debug Sql statements is a better choice than debugging in the .NET Visual Studio environment. I generally choose SQL Query Analyzer to debug SQL if the bug is narrowed down to the SQL stored procedure. If you have n
Web Parts in ASP.NET 2.0
(Jesse Liberty) In a previous article, I discussed how personalization works. This article will pick up from where that one left off and show you how to use Web Parts to allow your users to further personalize their interactions with your web site.