(Dan Sullivan) SQL Server 2000 has a scalar data-type system that defines data types such as int or float, which DBAs commonly think of as “primitives” because they contain values that you can’t break down further into components. However, SQL Server 2000 doesn’t provide a practical way to extend th
Other News
XML Case Study: Converting Excel Diaries to XML
(Stephan Onisick) Excel workbooks are extremely versatile at calculating and graphing workbook data. But workbooks don’t make an ideal repository, given Excel’s inherent size limitations and less-than-stellar access by other enterprise applications. This article explores the process using VBScript t
Government Workers Say Goodbye to Paper
(Stephan C. Kammerer) The need to comply with a multitude of regulations is pushing the public sector toward digital records management technology. A joint SAP-IBM solution promises to build efficiency into the process.
Altering and Dropping Databases And Tables In Microsoft SQL Server 2000
(Gayathri Gokul) Transact-SQL is central to the use of Microsoft SQL Server. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application’s user interface.It is trivial that we master some of the basics T-SQL, which you will b
Information Management Tools Update : What’s new in DB2 and IMS Tools for zSeries
Autonomic computing is a hot topic in IT circles these days, and for good reason. Technology that automatically detects and remedies problems is a tantalizing prospect. In this timely Webcast, you’ll discover how IBM tools for DB2 Universal Database and IMS software employ autonomic computing capabi
Using Coalesce
The arguments are evaluated in the order in which they are specified, and the result of the function is the first argument that is not null. The result can be null only if all the arguments can be null, and the result is null only if all the arguments are null. The selected argument is converted, if
Python and DB2 for Linux
(Patrick O’Brien) Python is a great tool to use with DB2 Version 8. It combines the ability to quickly and simply access a DB2 database with the power to perform more complex tasks that require a general-purpose programming language. You’ll learn about the Python DB2 module using the sample that shi
Converting Strings to .NET Framework Data Types
If you want to convert a string to a .NET Framework data type, use the XmlConvert method that fits the application requirements. For a list of all conversion methods available in the XmlConvert class, see XmlConvert Members. The string returned from the ToString method is a string version of the
A Brave New (Spatial) World
(W. Fredrick Limp) Oracle began shipping the latest release of its database software, 10g, in mid-February 2004. Although Oracle is correctly touting its new manageability and GRID capabilities, it also has some significant new spatial capabilities. The following is a combined product review (like G
Build an RSS DataList Control in ASP.NET
(Philip Miseldine) RSS is finally getting the recognition it deserves. SitePoint now publishes RSS, and large news agencies like the BBC, the New York Times and CNN also publish RSS feeds. Now, developers can integrate content from a wide range of producers within their own applications, giving user