(Arthur Fuller) You have a SQL Server table with n columns containing integers, floats, money, or dates, and it’s your task to return the maximum value contained on a row from these columns. You may even be required to do this for multiple rows at once, returning a record set.
Other News
SchemaBinding option in views
(Abey George Peter) Views can be thought of as a virtual table or stored query. The results of view are not stored in database (except for indexed views). The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables
You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use ‘localhost’ in the pipe name
On a Microsoft Windows XP-based computer or on a Microsoft Windows 2000-based computer, you use the Named Pipes protocol to connect to a local instance of Microsoft SQL Server 2005 or Microsoft SQL Server 2000. When you use “localhost” in the pipe name, you cannot connect to the instance of SQL Serv
DB2 9 Fundamentals exam 730 prep, Part 7: Introducing XQuery
(C. M. Saracco) DB2 9 features support for XQuery, an industry-standard language designed expressly for querying XML data. With XQuery and DB2 9 you can retrieve entire XML documents or XML fragments stored in XML columns. You can also specify XML-based filters for queries, transform XML output, and
Understanding the Falcon Transaction Storage Engine – Part 3
(Robin Schumacher) In Part 1 of this article series, we looked at how the Falcon transactional storage engine was architected and how it compared to some of the other MySQL storage engines. Part 2 covered how Falcon handles transaction management and concurrency. In this final article in the series,
Delivering Productivity with Choice
(Rich Schwerin) One of the more extensive examples of Oracle’s commitment to open source involves Eclipse, an open source community whose projects focus on providing a vendor-neutral open development platform and application framework.
Where is XML Going?
(Kurt Cagle) I did my prognostication schtick at the beginning of the year, but I thought given the resuscitation aspect of this particular blog, that I would go back and look at things in a little more depth, as I’m seeing a number of interesting, and in some cases disturbing trends that are unfold
Prints a Calendar for the Current Year
(Robert Ware) This tip prints a calendar for the current year. It can be modified to return other years as well.
Tivoli Federated Identity Manager Business Gateway and ASP.NET authentication
(Peter Cogill and Shane Weeden) In this article we show you how to enable your ASP.NET applications for federated single sign-on utilizing the Tivoli Federated Identity Manager Business Gateway (FIM-BG) and the plug-in it provides for Microsoft Internet Information Server Version 6 (IIS). Your exist
Ten Common Database Design Mistakes
(Louis Davidson) No list of mistakes is ever going to be exhaustive. People (myself included) do a lot of really stupid things, at times, in the name of “getting it done.” This list simply reflects the database design mistakes that are currently on my mind, or in some cases, constantly on my mind.