Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database systems. 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.
 

Lessons Summary
           

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
 

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
 

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
 

Transact-SQL Macros
EXISTS FILE_ID FILE_IDEX
 

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
 

References
Example Database Altair Real Estate Yugo National Bank
Georgetown Dry Cleaning Services | Department Store
Exam 70-433: Microsoft SQL Server 2008, Database Development
 
Previous Web Site Version (MS SQL Server 2005)
Previous version of this web site (For Microsoft SQL Server 2000)
Links
Mirror Site

Published on Thursday 02 October 2008 09:20
   
 

Databases
 

Transact-SQL Expressions
CREATE PARTITION BEGIN TRANSACTION
OUTPUT DELETED... COMMIT TRANSACTION
SELECT ... INTO ... ROLLBACK TRANSACTION
UPDATE ... SET
 

Transact-SQL Built-In Functions
ABS ASCII AVG
CAST CEILING CHAR
CONVERT COS COUNT
DATEADD DATEDIFF DEGREES
EXP FLOOR GETDATE
LEFT LEN LOG
LOG10 MAX MIN
POWER PI RADIANS
REPLACE RIGHT SIN
STDDEV SUM TAN
SIGN LOWER SQRT
VAR
 
 
 
 
FunctionX Press Microsoft Access C++ XML Delphi C# HTML MySQL .NET VBScript Win32
Windows VBA For MS Access Visual C++ Microsoft Word Object Pascal Oracle Microsoft Excel MS PowerPoint JavaScript Visual Basic 6
Copyright © 2008-2009 FunctionX, Inc.
Last Update: Thursday, 05 November 2009 16:09