Home

Microsoft SQL Server is an environment used to create computer databases on a Microsoft Windows operating system. It can deal with small databases such as a personal list of contacts. It can be used for a medium business such as a car repair shop. It is also used for a larger than medium set of records such as a super market or a local bank. It can also handle a very large database such as a country's census.

This site provides lessons and articles on how to use MS SQL Server to create databases. Our lessons assume that you have access to a computer that has Microsoft SQL Server installed. You can install a trial version of 180 days from the Microsoft web site.

Home
Home
 
1: Introduction to MS SQL Server 9:   The Records of a Database
2: Introduction to Databases 10: Introduction to Data Analysis
3: SQL Operations 11: Details on Data Analysis
4: Variables and Data Types 12: Operations on Data Analysis
5: SQL Expressions 13: Relationships and Data Integrity
6: Introduction to Functions 14: Data Joins
7: A Review of Built-In Functions 15: Views
8:  The Tables of a Database 16: Stored Procedures
SQL Expressions/Examples
Databases Tables Columns Functions
CREATE DATABASE CREATE TABLE Adding a Column CREATE FUNCTION
DROP DATABASE DROP TABLE Renaming a Column DROP FUNCTION
Renaming Deleting a Column
DEFAULT
SQL Expressions/Examples
Records
Create
DEFAULT
SQL Operators
AND BEGIN...END BETWEEN CASE ELSE FALSE
DEFAULT IF IS LIKE NOT NULL
ASC DESC OR MOD SET
ORDER BY IDENTITY PRINT DECLARE THEN
IN SELECT TRUE WHEN WHILE WHERE
PRINT SET
Built-In Functions
ABS ASCII CAST CEILING CHAR COS
CONVERT DATEADD DATEDIFF DEGREES EXP FLOOR
GETDATE LEFT LEN LOG LOG10 POWER
PI RADIANS REPLACE RIGHT SIN TAN
SIGN LOWER SQRT
Topics
Simple Data Binding: C# | MS Visual C++/CLI | MS Visual C# | MS VB | ASP.NET
Using a Parameterized Query: MS Visual C++/CLI | MS Visual C# | ASP.NET
Time Sheet: MS Visual C++/CLI | MS Visual C# | ASP.NET
Combo Box Data Binding
Example Database Mirror Site
Altair Real Estate Download this site (May 17, 2007 Version)
Yugo National Bank
Georgetown Cleaning Services Microsoft SQL Server 2008
Previous version of this web site (For Microsoft SQL Server 2000) Links
 
 
 
 

FunctionX Press MS Access C++ Managed C++ Delphi C# HTML MySQL .NET VBScript Win32
Windows VBA For MS Access Visual C++ MS Word Object Pascal Visual J# MS Excel MS PowerPoint JavaScript Visual Basic

Copyright 2003-2007 FunctionX, Inc.
Last Update: Tuesday, 06 September 2011 21:37