(Kent Milligan) I created the following function successfully in green screen STRSQL: CREATE FUNCTION MYLIB/FrstMthDay (DateIn DATE) RETURNS Date LANGUAGE SQL RETURN Date(DateIn – Day(DateIn) Days + 1 Day) (R)
Other News
Save disk space by compressing MySQL tables
The popular MySQL open-source RDBMS can handle tables containing hundreds of thousands of records without breaking a sweat. In fact, this scalability is one of the reasons it’s becoming so popular with large organizations and their massive databases.
Chart your path by unleashing the power of PHP in your next Web application
In this age of rapid application development and dynamic Web sites, the ability to code and deploy powerful applications quickly is in high demand. With strong development community support and an ever-expanding class library, PHP has become the default development platform for many projects. Th
Salvage Your Client-Side JavaScript Menus in ASP.NET Using XML/XSLT
(Moheb Missaghi) For the past several years, creating client-side JavaScript based menus using the browser’s DOM capabilities has been a popular way for developers to implement Web site navigation—so popular that there are now hundreds of Web sites offering free or commercial versions of such JavaSc
FIX: The batch job stops running, and job output is truncated when you run a Transact-SQL script as a SQL Server Agent job in SQL Server 2000
Consider the following scenario: • You have a Transact-SQL script. • You configure the Microsoft SQL Server 2000 SQL Server Agent to run this script as a job.
New Microsoft and Oracle initiatives eye mid-market
Software giants Microsoft Corp and Oracle Corp are both sharpening their focus on opportunities on small and medium sized businesses, a market that both companies still see as being largely underserved.
Notes/Domino 7 Revs Up iSeries Support
(Rita-Lyn Sanders) With more than 175 enhancements to Notes/Domino 7, IBM says there is something for everyone in the latest release of its collaboration portfolio. Yesterday, the company announced that the next-generation version of its e-mail collaboration platform, as well as the newest iteration
Database Abstraction in PHP
(Ian Gilfillan) In a previous job when I was responsible for hiring PHP developers, I always used to ask questions about database abstraction in my interviews. It’s amazing how often candidates with the best-looking CV’s, and impressive looking project lists, were tripped up by their lack of knowled
Ready or Not, Microsoft Expands DBA’s Role
(Charles Garry) Opinion: Emphasis on integration and coding in SQL Server 2005 forces database specialists to learn programmers’ tricks.
MDX Essentials: String Functions: The .UniqueName Function
(William Pearson) In this lesson, we will examine another function / property in the MDX toolset, the .UniqueName function. The general purpose of the .UniqueName function is to return the Unique Name of the object to which it is appended. .UniqueName can be used in conjunction with hierarchies, dim