Explore the Articles

Databases

Using Stored Procedures instead of Dynamic SQL

Applications that access SQL Server databases should make extensive if not exclusive use of stored procedures for any statement, from a very simple one-row select to a complex cascaded delete. Applications that paste together SQL statements are more difficult to manage and result in less secure databases than applications that exclusively use stored procedures.

Read More
Databases

Stored Procedures: An Overview

This article covers the basic of writing a stored procedure. It's the first in a series on writing stored procedures.

Read More
Databases

Text Search - CONTAINS

'CONTAINS' is a predicate used to search columns containing character-based data types for precise or fuzzy (less precise) matches to single words and phrases, the proximity of words within a certain distance of one another, or weighted matches.

Read More
Databases

Textual Searches on File Data Using Microsoft SQL Server

This article discusses facets of Microsoft SQL Server 7.0 textual searches such as: how SQL queries can be used on file systems lacking tables; how to use SQL extensions to make full-text queries; and how to work with a combination of file and database information. This article also discusses how BackOffice products (including: SQL Server distributed queries, Window NT Server's built-in Web Server, Internet Information Server (IIS), and Index Server 2.0) support textual searches in SQL Server 7.0

Read More
Databases

E-commerce Database Design - Part II

This is the second installment in an explanation of Database Design for Ultradev E-commerce application developers. It's based on my database experience (and all the mistakes I made along the way) with building E-commerce apps in Drumbeat 2000. I hope it's helpful

Author: Rick Curtis

Read More
Databases

E-commerce Database Design - Part I

This is the first installment in an explanation of Database Design for Ultradev E-commerce application developers. It's based on Rick's database experience with building E-commerce apps in Drumbeat 2000.

Author: Rick Curtis

Read More
Newer articles