web analytics

Tagged: MySQL

Migrate from MySQL to SQL Server 0

Migrate from MySQL to SQL Server

Reading Time: 1 minuteMigrate from MySQL to SQL Server with ease. Microsoft has launched a small utility to migrate a database from MySQL to SQL Server. Name of the utility is SQL Server Migration Assistant for MySQL....

Find week start/end given week number 0

Find week start/end given week number

Reading Time: 1 minuteI have a table with some dated records. I wanted to do some weekly reports on this data. MySQL has a nifty function dubbed WEEK() which will return a week number. It allows you...

MINUS query in MySQL 0

MINUS query in MySQL

Reading Time: 1 minuteMysql does not support MINUS operator which is not the end of the world. For most queries you can really care less if it’s implemented or not. My web app never needs to use...