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 learningcomputer.com 

In addition, I have my new personal page at kashefmughal.com, so check it out.

The databases we are interested in are

        SQL Stored Procedures (example 1, example 2)

        SQL Triggers(example 1, example 2)

        Table commands(drop table,delete table,truncate table)

        Foreign Key constraint

        SQL Joins (old_style, ANSI style)

        Importing ASCII data into SQL Server

        Bulk Copy Program

        OPERATORS

        SQL Views(example 1, example 2)
 

        Using SQL Server Browser to access data

        load table

        unload table

Transact SQL commands

INSERT INTO

DELETE FROM

UPDATE

UPDATETEXT

SELECT..FROM

SELECT MAX ..FROM

SELECT COUNT .. FROM

SELECT DISTINCT..FROM

SELECT..FROM..WHERE

SELECT..FROM..ORDER by

CREATEINDEX

CONVERT

Visual Basic 6.0:

    Declaration of variables and constants

    Selection structure

    Repetition structure

    String Manipulation

    Sequential and Random Files

    Pathology Data project

    Database utility project

Send comments and questions to kashefm@mail.com