SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Les Smith

SQLServerCentral.com profile

I am a database developer working with SQL Server and Oracle8i. My focus is on data warehousing, reporting and analysis. The tools I use are Java, Stored Procedures, Visual Basic and commercial applications such as Informatica. I am currently working at an Application Service Provider company in Silicon Valley.

   Items 1 to 6 of 6   

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.   Read more...
By Les Smith 2001/08/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,093 reads

Using Cursor Metadata to Dynamically Generate HTML Tables

The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.   Read more...
By Les Smith 2001/07/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,674 reads

Using COM to Output Queries to a Text File

This article presents a method of outputting the results of a query as a tab delimited text file using COM.   Read more...
By Les Smith 2001/07/20 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 6,566 reads

Storing and Retrieving Binary Data in SQL Server

Sometimes it is necessary to save binary data such as zip files, pictures or office documents into the database. This article looks at a way of using Java to perform this task.   Read more...
By Les Smith 2001/08/07 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 7,239 reads

Aggregating a Set of Hierachical Records

A great deal of data in any RDBMS is hierarchial. This article presents a technique for aggregating this data.   Read more...
By Les Smith 2001/08/22 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 3,025 reads

Using Java to Encrypt Passwords

Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.   Read more...
By Les Smith 2001/07/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 13,419 reads
   Items 1 to 6 of 6