Post reply

List of All sql statements

  • January 3, 2012 at 3:12 pm

    #248388

    I was going through books online today and thought it would be cool to find a list of all sql statements that could be used in writing a query (such as "select", "where", etc). I looked online to see if I could find anything but only thing I found was for Sql Azure, and the list looks a little small (link is below).

    http://msdn.microsoft.com/en-us/library/windowsazure/ee336270.aspx

    Anyone know of a way to get this list. I realize it is a silly request, but thought possibly someone out there had a list or knew of one.

    Thanks in advance. 😀

  • January 3, 2012 at 3:25 pm

    #1428023

    http://msdn.microsoft.com/en-us/library/ms189826(v=SQL.90).aspx

    http://msdn.microsoft.com/en-us/library/bb510741.aspx

    "To find more information about any specific statement, either search for the statement by name in SQL Server Books Online, or use the Contents to browse the 1,800 language elements listed alphabetically under Transact-SQL Reference (Database Engine). Another good strategy for finding information is to search for key words that are related to the subject matter you are interested in. For example, if you want to know how to return a part of a date (such as the month), search the index for dates [SQL Server], and then select dateparts. This takes you to the topic DATEPART (Transact-SQL). As another example, to find out how to work with strings, search for string functions. This takes you to the topic String Functions (Transact-SQL)."

    http://msdn.microsoft.com/en-us/library/ms365303.aspx

  • January 3, 2012 at 3:30 pm

    #1428025

    Open this page:

    http://msdn.microsoft.com/en-us/library/ms189826(v=sql.90).aspx

    The list on the left is relatively complete. It's missing a few things like MERGE and INTERSECT, but it'll get you started at least. I don't know of a single comprehensive list.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • January 3, 2012 at 3:32 pm

    #1428026

    Thanks guys!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply