Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server est une application informatique qui permet de créer des banques de données pour de petites entreprises, des grandes compagnies, et des systemes pour le web. Microsoft SQL Server est utilisée à différents niveaux et avec différents objectifs.

Ce site Web fournit des leçons et de sujets sur les différentes techniques d'utiliser Microsoft SQL Server 2008 pour créer et gérer des bases de données..

 

Sommaire des Leçons

           

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
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    
 

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
Exam 70-433:©Microsoft SQL Server 2008, Database Development
 
 
   
 

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
 
 
 
 

                   
                   

Copyright © 2009-2010 Yevol  
Last Update: Wednesday, 14 July 2010 09:13

site