PDF documents require
Adobe Acrobat Reader,
available free at:

 

 

SQL Database Related

Oracle9i Reference PDF

ODBC Ping

DTSBackup2000

SQLcheck

SQL Visualizer

SQLsafe

SQLMonitor

 

Universal Database Tool

 

 

Conceptual ER

Logical Design

Unary / Ternary

 
home mail contact Us site map
 

Oracle9i Quick Reference w architecture chart

MS SQL 2K ODBCPing command line tool - Q138541 MSKB

DTS Backup and Transfer of packages - MSSQL 2K

SQL Server performance monitoring tool - freeware

SQL Visualizer (MS SQL2K, 2K5) - client DB query / management

SQL Safe Backup - freeware Edition

SQL Monitor - freeware

Cpture all SQL calls the Toad program sends to the database via the client DLLs - Quest Software

Maestro SQL DBA tools - freeware

 

 
Conceptual Modeling (Entity-Relationship Diagrams)

Logical Database Design (Relational Model)

Logical Database Design (Translating Unary & Ternary)

 
 

 

 

SQL (Structured Query Language) is a syntax for executing queries.

 

The SQL language also includes a syntax to update, insert, and delete records.

These query and update commands together form the Data Manipulation Language (DML) part of SQL:

 

  • SELECT - extracts data from a database table

  • UPDATE - updates data in a database table

  • DELETE - deletes data from a database table

  • INSERT INTO - inserts new data into a database table

 

The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables.

The most important DDL statements in SQL are: 

  • CREATE TABLE - creates a new database table

  • ALTER TABLE - alters (changes) a database table

  • DROP TABLE - deletes a database table

  • CREATE INDEX - creates an index (search key)

  • DROP INDEX - deletes an index

 

  
To identify the installed version of SQL Server 2000 Database Components

Execute one of the following queries against an instance of the database engine by using isql, osql, or Query Analyzer.

SELECT SERVERPROPERTY('ProductLevel')
SELECT @@VERSION
SELECT SERVERPROPERTY('ProductVersion')



Find out your version of Database Components by means of the following table.
 
  SQL Server 2000 Version and Level @@VERSION Product Level  
  SQL Server 2000 Original Release 8.00.194 RTM  
  Database Components SP1 8.00.384 SP1  
  Database Components SP2 8.00.534 SP2  
  Database Components SP3, SP3a 8.00.760 SP3  
  Database Components SP4 8.00.2039 SP4  

Note -- Your product version may be different than these values if you applied a hotfix after installing the product or after installing a previous service pack.


(Optional) If you are not sure whether you are running an edition of the SQL Server 2000 database engine or MSDE 2000, use isql, osql or Query Analyzer to execute the following query against the instance in question.

SELECT SERVERPROPERTY('Edition')
 

 

  
Any material furnished by Nickerson Consulting Group, N-cg.net, is furnished on an "as is" basis. Nickerson Consulting Group makes no warranties of any kind, either expressed or implied as to any matter including, but not limited to, warranty of fitness for a particular purpose or merchantability, exclusivity or results obtained from use of the material. Nickerson Consulting Group does not make any warranty of any kind with respect to freedom from patent, trademark, or copyright infringement.

 
© copyright 2008 created by www.ITCharts.com