This site will primarily focus on T-SQL used with Microsoft SQL Server. Most examples are for Microsoft SQL Server 2005, but most will work for earlier and later editions. The site will be updated as new editions of SQL Server are released. The Pages that aren't not linked in the navigation bar, have not yet be completed. Please help us complete the pages by giving a small donation (Button on left menu bar).
For those just starting with SQL Server, some definitions are provided below:
SQL stands for Structured Query Language. It is most often pronounced "sequel" or sometimes pronounced by spelling out the letters "S-Q-L". SQL is a query language that is used to interact and perform tasks with relation databses. This language was originally developed by IBM in the 1970s.
T-SQL (Transact SQL) is a proprietary SQL extension used by Microsoft SQL Server and Sybase SQL Server. T-SQL adds extensions for procedural programming.
A Relational Database is a method of structuring data in the form of records so that relationships between seperate entities and attributes can be used for data access. A database stores the data in two-dimensional tables (relations) that can be joined by keys in one or more columns (attributes)
A RDBMS (Relational Database Management System) is the software system that manages a relational database. Examples of a RDBMSs are Microsoft SQL Server, Oracle, MySQL, Microsoft Access, DB2, Sybase SQL Server.
|
