Recently I have taken on a new role at work which involves working heavely with SQL. I have had limited expreience with SQ I have set up some drupal websites and done a small amount of work with PHP and SQL ( Mainly hacking other peoples pages to get what i wanted).
Taking on the new role has ment that i need to get my hands dirty and get to know it slightly better.
So far the whole experience has been good. For the very basics I have used www.w3schools.com/SQL but it seemed to be lacking some basics (plus) information. So what i am going to attempt to do is add to this blog information and examples as i use them. I know this infromation is in a 101 and 1 places but I always seemed to be missing a bit of information. Lets see how it goes.
Bit of background on the setup I am using…
Windows 2003 RC2
IIS6
MSSQL 9
PHP5.