DatabaseJournal.com Staff

Creating an Access database to use. Generally when you start up access, it gives you the option of opening an existing database or creating a new one. For the purpose of this tutorial, im going to assume you are going to create a new database. Start up Access. If Access is already running, close all […]

If you are anything like I was when you began your search for knowledge on Microsoft’s .NET technology, you were quite confused when first confronted with ADO.NET and how to implement it within your ASP.NET pages. This series of articles will first be a simple overview of what ADO.NET is, and second, will be a […]

download code for this article Transforming XML data with XSL is a great way to deliver formatted content to the web. Although creating XSL stylesheets can be daunting for the initiated, the new ExportXML method in Access XP makes it easy to publish even the most complicated reports. The following article will show how you […]

Here’s a script I wrote for returning fiscal dates. We use the 4-4-5 calendar here at my work, and so my queries often have to reference date ranges that must fall at the start of the correct periods. Our 2002 fiscal calendar started on 9/30/01 and this is used as the offset for calculating all […]

This function is similar to the TitleCase script submitted by Darryl Fryatt called TitleCase. I created a similar function and, after comparing the efficiency of the two scripts, found this function to be twice as fast. The function I call fn_mCase will take a string up to 8000 characters and capitalize the first character in […]

Microsoft released SQL Server 2000 Enterprise with a supported model for log shipping similar to the back office model in SQL Server 7.0. However, Microsoft seemed to have forgotten to add the model into 2000 Standard. I developed this script initially to migrate databases from 7.0 to 2000 and then continued it as a single […]

Here’s a small script that will perform a backup of all the databases into a specified directory (d:backup testing by default). The script needs to be run in master database and has been tested both in SQL Server 7.0 and 2000. Author: C.S. Senthil Kumar Download Script: backupdatabase.sql Disclaimer: We hope that the information on […]

If you use SQL Server 2000’s extended property features to document your database tables, this stored procedure can provide an easy way to extract the table and column-level descriptions for reporting purposes. This procedure can easily be modified to provide additional information to suit your needs. The script works only on SQL Server 2000. Author: […]

For SQL 7.0 and above this example code as a stored procedure provides information on how to embed Radial searching into your application. For instance, if you want to query all distributors of a certain widgit within the radius of 15 miles from your house, then you will want to take a look at this. […]

This script will create a text report to be emailed to the administrator showing which tables passed or failed replication. In this case, each publication containes one article which containes one table. The script has been tested on SQL Server 7.0. Author: Richard Fennimore Download Script: ReplicationValidation.txt Disclaimer: We hope that the information on these […]

Select Case allows you to present data in various ways. You can take numbers and return text values and express certian conditions based on the value of a certain column. Another example would be that you have a table “Naughty_Nice” in the Santa Database, with a data column Nice (INT Datatype). There are two distinct […]

Three Small Admin Scripts Here’s a package of three small administrative scripts for adding fields, dropping fields, and checking to see if a specific field exists in a table. Here’s a brief description for each of the scripts: spGetFieldsExists takes a tablename and a field name, and checks if that field exists in the table. […]