Microsoft SQL Server Database Development
Microsoft SQL Server 2008

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
     
   
sam gurgis counter
Copyright © 2011, Fianga.com Contact