SQL Server Examples

This is where you will find SQL Server Code Examples and snippets for SQL Server 2005, SQL Server 2000 and SQL Server 7.0. Our examples are based upon our training manager database which you can download from here. You can also download the data to load into the database as well.

Course Registration Database

SQL DML	String Functions	Stored Procedures
Select Update Insert Delete	Substring function Upper and Lower functions LTRIM and RTRIM functions	Select stored procedure Update stored procedure Insert stored procedure Delete stored procedure
SQL VIEWS	SQL TABLE BASICS
SQL Views - Basics	Create SQL Table Foreign Key Constraint Data Types Add / Alter Column Drop Table

SQL Server Examples

SQL Server Code Examples

SQL DML

String Functions

Stored Procedures

SQL VIEWS

SQL TABLE BASICS