Microsoft SQL Server;step by step

Microsoft SQL Server . It is a system for database management created by Microsoft , it is based on the relational model. Sel Server uses T-SQL and ANSI SQL as query languages.

Summary

[ hide ]

• 1 Features
• 2 Project version history
• 3 Internet-Email integration
• 4 External links

Characteristics

Microsoft SQL Server revolutionizes the concept of Database for Business. It brings together in one product the power needed for any critical business application along with management tools that minimize the cost of ownership. With Microdoft SQL Server, the company has everything as standard.

Among its fundamental characteristics are:

• Transaction support.
• Scalability, stability and security.
• Supports stored procedures.
• It also includes a powerful graphical administration environment, which allows the use of DDL and DML commands graphically.
• It allows working in client-server mode, where information and data are hosted on the server and the terminals or clients of the network only access the information.
• It also allows managing information from other data servers.

Project version history

Internet-Email integration

• MAPI, allowing workflow applications and automatic data change notification.
• Compatibility with Microsoft Internet Information Server and other popular Web servers.
• SQL Web Assistant, for automatic return of data in HTML format.
• Stored proceduresfor generating HTML pages or updating data in Web templates.
• Ability to automatically populate Microsoft Exchange public folders with data.