Please direct me to a good book on ANSI SQL. I am already familiar
with Sybase and MS SQL, but I want something that shows the
"standard". A plus would be if it offered a comparison between the
standard and MS or Sybase. querying xml from sql server using ado.net and c#:: Right, the FOR XML option formats your SQL query results into an XML result, (formatted based on some xml structure that has nothing to do with the xml http://answers.google.com/answers/threadview?id=448358HOME |
Thank you, both.
First some general background- the 3 most common types of SQL are
ANSI SQL - the standards board(ANSI) that tries to standardize between sql
PL-SQL - Oracles Implementation of SQL
Transact (T-SQL) Microsoft and Sybase's version.
Sybase was the basis of Microsoft SQL Server but they have branched significantly.
A couple of good books:
SQL for dummies (my first book) - Allen Taylor
A beginner guide that is a good refernce.
SQL Bible by Alex Kriegel
A good overview of ANSI SQL
SQL - The Complete Reference -by James Groff
A good reference guide
Here is the link to standards document online
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt How do I BACKUP/DUMP my SQL Server 2005 DB with :: I'm fairly inexperienced with database work, and maybe that's why I thought that it might be a simple matter of executing an appropriate SQL query to get http://answers.google.com/answers/threadview/id/781934.htmlHOME | Need help with complex SQL statement (MySQL database):: 123 I need an SQL query that produces the following result: Birch comes a new table structure, computer with SELECT statements to achieve what you want. http://answers.google.com/answers/threadview/id/161188.htmlHOME |
Nortel Unveils Vision, Strategy for Israeli High-Performance Net
Busy Friday Leads to Strong Close for Net Stocks
|