[SQL_Server简介外文翻译.docxVIP

外文原文Introduction to SQL ServerBy SamuelRelational databases have been around for 30 years, but they were not the original kind ofdatabase, nor are they the newest kind of database. XML and object-oriented data structures haveevolved in recent years. But relational databases are still by far the most popular kind of databaseavailable and will be for some time to come.SQLis the abbreviation ofStructured Query Language and it is for relational databases, as the title indicates this is only for fresher who has just started the carrier or who iswaiting to open up the carrier in the application programming side. But that does notmean this article is a tutorial for a fresher who does not know anything about SQL.This article is meant for who already have a little knowledge in SQL and want toimprove it.What Does SQL Do?First, SQL is the premier tool for viewing information from a relational database. It doesn’t justgive you a data dump. SQL gives you sophisticated tools to summarize, consolidate, and calculatefrom the data. Using table relationships, data can be combined from multiple tables in a numberof ways. With a properly designed database, SQL can answer practically any question about thedata.Second, SQL provides commands to manipulate the data in a relational database. Recordscan be updated and added to or deleted from a table. Here is SQL as a database language reallyshines. Procedural programming languages, such as BASIC, might require several lines of code toupdate a record in a database table. In addition, procedural programming languages would haveto use some sort of looping structure to repeat this process on every record. SQL operates on anentire set of records all at the same time. SQL is like haiku for programmers; often a dozen wordsor fewer can delete or change thousands of records.Finally, SQL is a complete data definition language (DDL). The database itself can becreated along with all tables, fields, primary keys, and relationships. Add to that the recor