Friday, 15 July 2011

Simple SQL statement

 /*
SELECT *
  FROM
    tables(s)
    subqueries (as derived tables) AS NamedRangeAlias
    common table expressions (CTE)
    views
    table-valued user-defined functions
    distributed data sources (OpenQuery) 
    XML data sources (XQuery)
*/

SELECT 'SQL Rocks';

SELECT *   FROM Tour;

-- Fully Qualified - Four Part Name

-- SELECT * --   FROM Server.Database.Schema.Object;

SELECT *   FROM dbo.Tour;
SELECT *   FROM dbo.Tour;