SQL Book

[johnny_coffee]

Can anyone recommend a decent book on SQL, covering all the standards as well as focusing on MS SQL Server & My SQL for me please?

[The Milky Bar Kid]

Would be interested to see what is recommended myself, I need to pick up something similar.

[Qu1zMaster]

SELECT book FROM shops.Eason, shops.Waterstone, shops.Hodges_Figgis
WHERE content=good AND price='not too dear';

[Rowche Rumbler]

VALUE=lol

[cadence]

SELECT book FROM shops.Eason, shops.Waterstone, shops.Hodges_Figgis
WHERE content=good AND price='not too dear';

SP2-0044 For a list of known commands enter HELP and to leave enter EXIT

[TheFunkeyGibbon]

SELECT book FROM shops.Eason, shops.Waterstone, shops.Hodges_Figgis
WHERE content=good AND price='not too dear';

Or Amazon. Though don't forget to add:

ORDER BY Post

To that statment...

[TheFunkeyGibbon]

There's a good list at The Register's Cash and Carrion:

http://www.cashncarrion.co.uk/sql/560/0

[johnny_coffee]

select * from thread84247 where answers='useful'


0 rows returned ;)

edit: cheers TFG I'll havea look through those

also found this
http://www.w3schools.com/sql/default.asp

[cadence]

There's a good list at The Register's Cash and Carrion:

http://www.cashncarrion.co.uk/sql/560/0

thats 3 books. Is there a specific recommendation, or is it a short list of good books ?

[Hack]

This is a good beginner site (http://sqlcourse.com/), it's interactive maaaan.

[TheFunkeyGibbon]

A short-list, a good place to start (I've not read them all!).

It really depends on what level you are looking at - I could suggest a beginners book but that might not be what you are after.

[cadence]

select * from thread84247 where answers='useful'


0 rows returned ;)

edit: cheers TFG I'll havea look through those

also found this
http://www.w3schools.com/sql/default.asp

I don't think the quiz is a good indicator.

16 of 20

80%

Almost! Study a little more and take the test again!

Time Spent
4:31

I have never programmed a single line of sql. Any knowledge I have is theory from over 10 years ago, so treat results with a pinch of salt.

[Qu1zMaster]

It will all come back to you and soon you will be flying.

[ideefixe]

AAAAAAAAAAAA this thread is giving me trauma. I've been writing stored procedures for the last hour. I've even been fucking DREAMING stored procedures recently.

Microsoft SQL Server 2000 Bible by Paul Nielsen, published by Wiley. My boss uses it and my boss is Teh Whizz at SQL Server. The T-SQL help in SQL Server Query Analyzer is also pretty good.

[Dot.Bomb]

*hijack*

I've done this loads of times before but my brain is not coming up with the goods this morning.

I'm trying to extract the first few digits of a serial number (as in first 4 of 10, and up to the first '-'), anyone know what SQL will do this for me?

[Dell]

I'm such a nerd. I laughed out loud (yes actually lol) at this thread. Good ideas too. Thanks.

[ArseBurger]

Any O'Reilly book

[Pete]

*hijack*

I've done this loads of times before but my brain is not coming up with the goods this morning.

I'm trying to extract the first few digits of a serial number (as in first 4 of 10, and up to the first '-'), anyone know what SQL will do this for me?

For MSSQL you would use the SUBSTRING and CHARINDEX functions, for Oracle you would use SUBSTR and INSTR functions.