SQL Server syntax in one document

Question

SQL Server syntax in one document

Aaron N. Cutshall

SSCrazy Eights

Points: 9014
More actions
April 24, 2015 at 9:34 am

#317025

Does anyone know if a single document or book (in an eBook format) that contains all of the SQL Server syntax available? What I'm looking for is spread out amongst the TechNet library pages such as this:
SELECT select_list
[ FROM table_source ]
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]
Having it all in one document for all DDL and DML statements would be VERY handy!
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

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

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Aaron N. Cutshall (4/24/2015)
Does anyone know if a single document or book (in an eBook format) that contains all of the SQL Server syntax available? What I'm looking for is spread out amongst the TechNet library pages such as this:
SELECT select_list
[ FROM table_source ]
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]
Having it all in one document for all DDL and DML statements would be VERY handy!

All of the syntax available for sql server??? Are you kidding??? The document would be too big to read. That is why technet has it across so many pages. There are literally hundreds or thousands of statements with many options for each one.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Aaron N. Cutshall SSCrazy Eights Points: 9014 More actions · Answer 2

Sean Lange (4/24/2015)
All of the syntax available for sql server??? Are you kidding??? The document would be too big to read. That is why technet has it across so many pages. There are literally hundreds or thousands of statements with many options for each one.

You have a very good point Sean. I wasn't looking for all of the explanatory text, just merely the syntax itself. The way it's currently structured requires one to constantly jump back and forth among various pages and it kills quite a bit of time traversing the tree in this manner.

LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Aaron N. Cutshall (4/24/2015)
Sean Lange (4/24/2015)
All of the syntax available for sql server??? Are you kidding??? The document would be too big to read. That is why technet has it across so many pages. There are literally hundreds or thousands of statements with many options for each one.
You have a very good point Sean. I wasn't looking for all of the explanatory text, just merely the syntax itself. The way it's currently structured requires one to constantly jump back and forth among various pages and it kills quite a bit of time traversing the tree in this manner.

My guess is that if you had a single document stripped down like your example it would also take a lot of time to find the statement you are looking for. How often do you need to look at all syntax options for a given statement?