• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Database Essentials > Basic SQL Syntax

Basic SQL Syntax

The Structured Query Language (SQL, pronounced “sequel”) is the standard language used by all RDBMS to define, retrieve, and manipulate data. Each RDBMS has its own version of SQL, which is derived from the standard SQL. The variations can be in syntax or keywords. In the following sections, you will learn to use Transact SQL (T-SQL), which is the version of SQL used in SQL Server7.0. Most of the T-SQL statements discussed in this chapter are similar to the standard SQL (ANSI SQL). However, a note has been added to all the T-SQL statements whose syntax differs from the standard SQL (ANSI SQL). In SQL Server, you enter SQL statements in the SQL Server Query Analyzer window.

Creating Databases and Tables

The first step toward implementing the database design is to create a database. To create a database use the following command:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint