I have started building out my MS SQL to MySQL translation post. I have decided that I am going to tell the whole "story" in MS SQL 2005 before I even try to attempt any of it in MySQL. I feel like this will help me get it done faster - not having to stop all the time to figure out how this is done in MySQL at ever step of the journey. Here is what I have added:
- Drop Table If It Exists - MSSQL
- Create Table - MSSQL
- Populate Table - MSSQL
I have decided to go with actual tables where I would usually have gone with temporary, in-memory tables since it seems that temp tables are not a very widely supported property of database systems. This already makes me feel uncomfortable. This is such an awesome feature of Microsoft SQL server; I use temp tables all the time to break down huge SQL algorithms into smaller, more manageble steps.