Before you write any SQL test case, you need to define what you want to test and why. For complex queries ... files and run them using SQL Server, Oracle, MySQL, or PostgreSQL.