You may use an object of the ServerXMLHTTP class to establish an HTTP connection to a Web site. When the Web site redirects your request to another Web site, the waitForResponse method of the ServerXMLHTTP class fails, and you receive the following error message: This method cannot be called unti
Other News
Find Last Entry from History
(Galina Petrenko) The following technique shows how to find the last record ( last entry ) from the history table. When the history table has a timestamp column, you can use an N-Row query with a descending sort on that column and get just one row. Use similar techniques when the timestamp column is
T-SQL’s Datetime Data Type
(Michael Otey) SQL Server’s datetime data type generates a lot of questions and confusion in the SQL Server community. Unlike some other major database platforms, SQL Server doesn’t provide discrete date and time data types. Instead, SQL Server’s datetime data type does the work of both. Here are an
Tutorial: Changing the Visibility Objects in Reporting Services
(Brian Knight) In the last tutorial in this series of Reporting Services tutorials we added conditional formatting to the report. Now that we’ve created our first report and have added a bit of flare to it, let’s go ahead and make it even cleaner. In this very quick demonstration, we’ll go ahead and
Basic SQL Coding for DB2 Universal Database for OS/390
(Susan Lawson) Up to now, we have discussed basic SELECT statements. The SELECT statement allows you to retrieve data from your database tables and assumes that data has been previously loaded into the tables. Now we will concentrate on manipulating data in tables using SQL. There are three main
A Simple Serializer / Deserializer
(Marc Clifton) I needed a simple serialization / deserialization mechanism to save and load state information for objects whose type (the class) is constructed and compiled at runtime. Neither XmlSerializer nor BinaryFormatter classes handle this scenario. So, I wrote a lightweight assembly to
Database Property Viewer Using SQL RS
In the article titled Understanding Reporting Services Web Service Access, we saw how the entire SQL Reporting Services can be controllled by using the web-service interface. We also built a sample application using the same. The very fact that you can control various aspects of Reporting Servic
Microsoft Reporting Services in Action: Extending Microsoft SQL Server 2000 Reporting Services with Custom Code
(Teodor Lachev) This article presents an excerpt from the book Microsoft Reporting Services in Action. Learn how to implement advanced report functionality using custom code.
Manage Development and Production Database Connection Strings with XML Serialization
Database connection strings are an important part of any data-enabled application. Because developers typically have development and production connection strings to manage (depending upon the environment they are working in), many different strategies have been created to handle switching from deve
Scalar Sub-Queries in SQL Server
(Muthusamy Anantha Kumar) Scalar sub-queries return exactly one column value from one row. Scalar sub-queries can be used in CASE expressions, WHERE clauses, ORDER BY clauses and SELECT clauses. This article reviews a few examples of how to use scalar sub-queries in most situations.