Database Solutions for RDBMS applications

Welcome to my website. The purpose of this page is to discuss common database commands and problems associated with these commands. Feel free to send me questions and comments. If you want to learn basic information about computer software like Microsoft Office, Microsoft Windows etc., please visit the following site www.learningcomputer.com

The databases we are interested in are Microsoft SQL Server, Microsoft Access and Sybase SQL

Here are the tutorials for Minnesota School of Business

SQL Server 2000

Access 2000

Visual Basic.NET


Microsoft SQL Server	Transact SQL commands

SQL Stored Procedures (example 1, example 2) SQL Triggers(example 1, example 2) SQL Views(example 1, example 2) Foreign Key constraint SQL Joins (old_style, ANSI style) Importing ASCII data into SQL Server Bulk Copy Program OPERATORS Table commands(drop table,delete table,truncate table) Using SQL Server Browser to access data	INSERT INTO DELETE FROM UPDATE UPDATE TEXT SELECT..FROM SELECT MAX ..FROM SELECT COUNT .. FROM SELECT DISTINCT..FROM SELECT..FROM..WHERE SELECT..FROM..ORDER by CREATEINDEX CONVERT SELECT MAX ..FROM SELECT COUNT .. FROM SELECT DISTINCT..FROM SELECT..FROM..WHERE SELECT..FROM..ORDER by CREATEINDEX CONVERT

Sybase SQL Central

load table

unload table

Send comments and questions to kashefm@mail.com