I have an immediate problem of learning how to create a stored procedure to run under Sybase.
What websites are recommended for learning this and similar SQL techniques?
Downloading the Sybase help files got me started… They contain quite some examples.
Paul
Hi Morley
Had a quick look at some of my favourite SQL info sites - I generally find it helps to see things explained several times …
Hope something useful for you here:
http://java.sun.com/docs/books/tutorial … s/sql.html
http://sybernet.sri.com/guide.html
http://www.ics.com/support/docs/dx/1.5/tut6.html
http://mgd.nacse.org/hyperSQL/docs/docs … ction.html
Regards
GrahamG
Have good experiences with this book that I bought through Amazon
Sql Anywhere Studio 9 Developer’s Guide by Breck Carter
ISBN: 1-55622-506-7
HTH
Maybe a bit off topic, but I found Sybase and the documentation a bit overwhelming when trying to write some triggers.
Have now had a look at PostgreSQL. It is much more compact and understandable, the online documentation for version 8.0 is very good and there are a few books for version 7.0. PostgreSQL - Essential Reference for New Riders is nice and compact. Note that the syntax for triggers and stored procedures is more flexible in version 8.0 so if you are using the latest version, use the online documentation.
PostgreSQL + Aqua Data Studio works well together, at least on Mac OS X.