(Jayaram Krishnaswamy) In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In another tutorial we saw how to use the Query Builder, the graphical interface for fashioning and running SQL in
Author: SSWUG Research
SQL Server 2005 Query Notifications Tell .NET 2.0 Apps When Critical Data Changes
(Julia Lerman) )ne of the classic problems with database applications is refreshing stale data.
CodeSnip: How to Get Id of the Record Using ASP.NET and SQL Server 2000
(Sushila Bowalekar Patel) In this code snippet we will examine how to get Id of the newly added record using ASP.NET and SQL Server 2000.
New Features in Oracle 10g for SQL*Plus and iSQL*Plus
(James F. Koopmann) Don’t wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features that will make a few of your everyday tasks a bit more bearable.
V8, CM, Rebind, and Statistics: What do they all have in common?
(Willie Favero) You’re in V8 compatibility mode (CM) and you believed us when we suggested that you really should rebind your packages to take advantage of all the new optimization delivered in DB2 V8. . But is that really all you need to do? Well, maybe not.
Oracle bids for your unstructured data
(Peter Judge) Oracle has made a bid to manage the unstructured data in which companies are drowning — and one of the leading specialists in the field has jumped on board.
.NET Tip: Create a Custom Configuration Section in .NET 2.0
(Eric Smith) The configuration file concept in .NET makes it much easier to change runtime settings without having to recompile. These files hearken back to the days of .INI files in previous versions of Windows, long before the dreaded Registry. Although you can keep all your settings in the appSet
How to Retrieve and Cache HTTP Data in ASP.NET
(John Peterson) In today’s world of Web services and RSS feeds, it seems like every application you build needs to pull in data from somewhere. Luckily, ASP.NET makes retrieving data from a remote server via HTTP extremely simple… maybe too simple. Many applications are brought to their knees beca
Apply Operator
(Gregory A. Larsen) With the introduction of SQL Server 2005 T-SQL was expanded to include new functionality. The “APPLY” operation was one of the new T-SQL enhancements. This article will discuss the APPLY operator and provide a few examples of how it can be used.
List directory contents with VB.NET’s DirectoryInfo and FileSystemInfo classes
(Irina Medvinskaya) VB.NET offers two handy classes—DirectoryInfo and FileSystemInfo—that allow you to access directories, check their properties, and perform other basic functions on the file system. DirectoryInfo lets you get information about a directory, and create, move, and enumerate through d