I have one problem, I want to use same sql query in MySql and SqlServer. In case of Sql Server generally you have to write query in this way- select * from databasename.dbo.tablename but in case of MySql you have to write query in this way- select * from databasename.tablename. There is no problem if you write in this way- select * from tablename for both the database. But I have two tables of same name say 'employee' are in two different database and both having some relationship. So there is a need of writing database name while executing the table.
I want to write in such a way so that the query will run for both the database in MySql and SqlServer.
Thanks in Advance.