(Don Schlichting) This article focuses on using a stored procedure to insert a new record from data collected on a web page, then passing an identity value created from that row back to the web page. In the previous articles in this series, Part One described the benefits of using stored procedures

(Eric Johnson) SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a blur. In last month’s installment, we introduced the various versions of SQL 2005 and di

(Michelle Gutzait) One of my clients called me. The frantic communication went something like this: “Our applications started to do crazy things in the database,” said the client. “We don’t understand what is happening. New rows are added to one table and another table is changed. We successfull

(Jeremy Kadlec) Analysis Services was originally introduced with SQL Server 7.0 as the core backend technology for Microsoft’s business intelligence offering. Since the original release, the overall business intelligence offering has improved immensely for both the presentation and processing layers

(Eric Johnson) This July 1, the world’s best bicyclists will gather in northeastern France to kick off the planet’s most grueling event: the Tour de France, a 20-stage race covering more than 2,100 miles. The cyclists will zip through wheat fields, bounce over cobblestone streets and power up mounta

(Muthusamy Anantha Kumar) Microsoft introduced the EXCEPT operator in SQL Server 2005, which returns all of the distinct rows from the left side of the EXCEPT operator. It also removes all of the rows from the result set that match the rows that are on the right side of the EXCEPT operator.

(Vidya Vrat Agarwal) This lesson introduces you to the various components and services of Microsoft SQL Server 2005. Database administrators (DBAs) are often required to manage multiple aspects of a database server, not just the relational database engine. Therefore, an awareness of the components a

When you execute a query in SQL Server 2000 Analysis Services to retrieve a drillthrough result set, the result set contains data for the whole relational source. This problem occurs when the following conditions are true: • A cube role was defined for the relational source with the following set

(William Pearson) In this article, we will continue the examination of “MDX for drilling up and down” that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our subseries, stating that it comprises an analytical t

(Wade Wilbur) An issue came up recently where a client needed to wait a certain number of business days before taking an action. To accomplish this I wrote a user defined function (UDF) in SQL Server 2000.