SQL in a Week

rmg1

For the size of table you're going to get, an index won't really help by much.
A full table scan will be just as quick.

::edit::

Unles you've got a table with several thousand bread/price variations and the server is on it's last legs.

paddyrg

rmg1 wrote: »

Unles you've got a table with several thousand bread/price variations and the server is on it's last legs.

That's Paddyrg Bakers for you - I have several dozen different prices for each dough product ;-)

Polymath

This reminds me of the old COBOL statement where the fields seem to be misordered:
DIVIDE 8 INTO CAKE GIVING SLICES

I_have_spoken

SELECT TOP 5 * FROM SQL_Books
ORDER BY Skill_Level ASC

Lakeuk

Work through http://www.w3schools.com/sql/default.asp

DigForVictory

Bless you all - I'm applying for a post where "familiarity with SQL would be an advantage" & while I did a bit decades ago, everything went object oriented whilst I was having children.
Now to arrange a bit of computer time...

Ximian

Bunch of geeks hijacked this thread

All you need to know for SQL is:

tick or tick1tick=tick1

Hoping no input sanitisation or parameterising queries present.

[Deleted User]

Here's something useful then:
http://www.headfirstlabs.com/sql_hands_on/

It lets you play around with some SQL online and get to grips with writing simple select queries

I cut my 'database' teeth on PHP/mySQL, then slowly moved up to playing with propitiatory reporting languages and TSQL

jaydeeuk1

WTFH wrote: »

Indices are for people who want information in a hurry. I get paid by the hour.

I like the way you roll. I've been using SQL (SQL Server 2000 onwards) for 10 years, and I've barely scratched the surface of what can be done with SQL. My limitations in SQL means I'm having to make up for stuff through server side code, mainly classic ASP still, meaning slower apps, more database hits, and then having to recode sections as I learn something new. As mentioned, a crash course will give you basics, such as being able to use unions, left outer joins, stored procedures and explain what and how they're used. I'm guessing you won't have to know about backups, transactional backups, disaster recovery, mirrored dbs, peer to peer db for your job? Otherwise thats a lot of stuff to cram lol


Delete from users where username <> 'jaydeeuk1'