Talk:SQL Exercises/The Hospital

Can't get this working in MS SQL Server Management Studio (T-SQL). After making a number of tweaks relating to identifier/keyword clashes, I run up against problems with some of the "CONSTRAINT (blah) REFERENCES someTable(blah)" lines. It looks to me like this code will only work under PostGreSQL? Magicalsushi (talk) 10:53, 19 July 2010 (UTC)

I have provided some MYSQL compatible code for generating the tables. Several names had to be changed to be compatible since some table fields were reserved words and to avoid other name conflicts. Tested on MYSQL 5. Jacoblee (talk) 04:04, 15 August 2010 (UTC)

Old style joins should be removed
In some of the solutions I see cases where the syntax is used. This is generally considered bad practice these days: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/08/bad-habits-to-kick-using-old-style-joins.aspx https://stackoverflow.com/questions/5654278/sql-join-is-there-a-difference-between-using-on-or-where/5654338#5654338 So if this is intended to teach newcomers to SQL it seems to me like this should be changed to the more explicit JOIN syntax. O&#39;society (discuss • contribs) 16:35, 18 August 2017 (UTC)