Home / server / Questions / 201520
In Process
user48642
Asked: 2010-11-14 09:31:04 +0800 CST

does select statement come under the category of Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL

  • 772

does select statement come under the category of Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL.

sql

1 Answers

  1. MS T-SQL Select: http://msdn.microsoft.com/en-us/library/ms189499.aspx

    SELECT [ ALL | DISTINCT ] 
    [TOP ( expression ) [PERCENT] [ WITH TIES ] ] 

    < select_list > 
    [ INTO new_table ] 
    [ FROM { <table_source> } [ ,...n ] ] 
    [ WHERE <search_condition> ] 
    [ <GROUP BY> ] 
    [ HAVING < search_condition > ]

    ANSI SQL Select: http://www.rawos.com/odbc/sqlguide/index.html

    SELECT [DISTINCT|ALL] *|{attr_name[ AS new_attr_name]} FROM {table_or_view[ alias]}
    [ WHERE where_criteria] 
    [ GROUP BY {attributes}[ HAVING condition]]
    [ ORDER BY {attrname|attrorder [ASC|DESC]}]
    [ INTERSECT|UNION[ ALL] SELECT_statement]

    Yes, T-SQL Select is an extended (and therefore likely proprietary) version of ANSI Select.

    • 1