SQL Server Tutorials
This document provides step-by-step instructions for installing Microsoft SQL Server 7.0, Enterprise Edition on Microsoft Cluster Server.
Install SQL Server 7.0, Enterprise Edition on Microsoft Cluster Server
Microsoft SQL Server 7.0 is the latest version of the SQL Server relational database product. With SQL Server 7.0, the Setup program has been changed from earlier versions of SQL Server Setup. This document is intended to provide information on the installation of Microsoft SQL Server 7.0.
Installing Microsoft SQL Server 7.0
Provides database administrators and developers with valuable information on Microsoft® SQL Server™ 7.0 index selection, disk I/O subsystem tuning, and SQL Server 7.0 performance tuning tools.
Microsoft SQL Server 7.0 Performance Tuning Guide
This article describes the process and discusses the tools you can use to migrate your Access database to SQL Server.
Migrating Your Access Database to Microsoft SQL Server 7.0
Simultaneously manage SQL Server 6.5 and SQL Server 7.0, determine whether you can pipe output from Query Analyzer into a text file, and discover how to remove decimal points from entries in a character column.
Questions, Answers, and Tips About SQL Server
Discusses compatability details when running SQL 7.0 on Windows 95 or Windows 98.
Running SQL 7.0 on Windows 95/98
Added: 08/09/2002, Hits: 278, Rating: 0, Votes: 0
Add To Favorites | Add Rating
This tutorial discusses how to enable access to remote data in Microsoft SQL Server 7.0.
SQL 7.0 Accessing Remote Data
This tutorial discusses ANSI-92 compatibility in Microsoft SQL Server 7.0
SQL 7.0 ANSI-92 Compatibility
This tutorial discusses the various backup types in Microsoft SQL Server 7.0
SQL 7.0 Backup & Restore Types
This tutorial discusses the Methods of Loading Data in Microsoft SQL Server 7.0. Examples are listed as the INSERT statement, the SELECT INTO statement,``the bcp utility, Data Transformation Services (DTS), and the BULK INSERT``statement.
SQL 7.0 Data Loading
This tutorial discusses database files and the creation and altering of a database in Microsoft SQL Server 7.0
SQL 7.0 Database Files
One of the great new features of SQL 7 is that it now has the ability to do full-text indexing, thanks to integration with Microsoft Index Server technologies.
SQL 7.0 Full-Text Indexing
How to rebuild the registry and master database in SQL Server 7.0.
SQL 7.0 Rebuild Utilities
Added: 08/09/2002, Hits: 252, Rating: 0, Votes: 0
Add To Favorites | Add Rating
This tutorial describes replication in Microsoft SQL Server 7.0.
SQL 7.0 Replication
Lists the installation requirements for SQL Server 7.0.
SQL 7.0 Requirements
In addition to user defined roles that you create to ease administration of permissions, there are also two categories of fixed, or pre-defined, roles. They are Database Roles and Server Roles. The table below summarizes these Fixed Roles. These are summarized in this tutorial.
SQL Server 7.0 Roles
SQL Server 6.5
This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
Backing up and Restoring your MySQL Database
A step by step tutorial that will make installing and configuring MySql on Windows Vista very easy.
Installing MySql on Vista
A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.
MySQL FAQs - Server Daemon mysqld Administration
A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.
MySQL FAQs - SQL SELECT Query Statements with GROUP BY
A collection of 17 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting and updating data rows; inserting and updating with subqueries; deleting data rows.
MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.
PHP Script Tips - Working with MySQL Database
In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
Retrieving Data in MySQL
The retrieved data is not displayed in a mere random order. If unsorted, data is typically displayed in the order in which it appears in the underlying tables. This could be the order in which the data was added to the tables initially. However, if data was subsequently updated or deleted, the order is affected by how MySQL reuses reclaimed storage space. The end result is that you cannot (and should not) rely on the sort order if you do not explicitly control it.
Sorting Retrieved Data
This free book is an excellent tutorial book for beginners. It is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, UPDATE, WHERE, Windows, XML.
SQL Tutorials by Herong