Microsoft SQL Server

Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database applications. It is used at different levels and with various goals. This web site provides lessons and topics on how to use Microsoft SQL Server 2008 to create and manage databases.

Table of Contents

SQL Expressions/Examples

Databases	Tables	Views
CREATE DATABASE	CREATE TABLE	CREATE VIEW
DROP DATABASE	DROP TABLE	ALTER VIEW
Renaming	Renaming	DROP VIEW


Columns	Records Operations

Adding a Column	Default Value	Creating a Record
Identity Column	Expression	Updating a Record
Deleting a Column	Allow/Disallow null	Deleting a Record
Renaming a Column	Unique Values

Functions and Stored Procedures

CREATE FUNCTION	CREATE PROCEDURE
DROP INDEX	ALTER PROCEDURE
	DROP PROCEDURE

Index & Triggers

CREATE INDEX	CREATE TRIGGER
DROP FUNCTION	ALTER TRIGGER
	DROP TRIGGER

Topics

Simple Data Binding: ASP.NET

Using a Parameterized Query: ASP.NET

Time Sheet: ASP.NET

References

Example Database	Altair Real Estate	Yugo National Bank
Ceil Inn
Georgetown Dry Cleaning Services \| Department Store
Exam 70-433: Microsoft SQL Server 2008, Database Development
An electronic book (ebook) version of these lessons is available for purchase

Mirror Site

Published on Saturday 26 February 2011 09:50

This web site was created on Saturday 26 February 2011

Objects

CREATE USER	CREATE VIEW
	ALTER VIEW
	INSERT INTO
	DROP VIEW

Transact-SQL Keywords

ALL	ALTER	AND
AS	ASC	BETWEEN
BEGIN...END	BY	CASE
CHECK	CLUSTERED	CONSTRAINT
CROSS JOIN	DECLARE	DEFAULT
DELETE	DISTINCT	ELSE
EXECUTE	FALSE	FOREIGN KEY
FULL OUTER JOIN	GROUP BY	HAVING
IF	IN	INDEX
INNER JOIN	INSERT	IS
JOIN	LEFT OUTER JOIN	LIKE
MERGE	NONCLUSTERED	NOT
NULL	OR	ORDER BY
OUTPUT	PRIMARY KEY	PRINT
REFERENCES	RETURNS	RIGHT OUTER JOIN
SELECT	THEN	TOP
TRUE	UNION	UNIQUE
UPDATE	USING	WHEN
WHERE	WHILE	WITH

Contact