MSSQL vs MySql

Hi,

I've been programming in php with a mysql DB for the last 3 years, I now need to shift my focus to php with a MS SQL db, does anyone know of any good explanatory manual or something where I can sharp up my knowledge on MS SQL ?

Kind regards

Try to visit msdn.microsoft.com.
Also MS SQL Server has most features that MySQL has, so I'm sure it won't be hard move.

Best regards,
Mikhail Krivoshein

so... are the functions used in php for accessing a mysqldb similar to accessing a mssql db

Eg. mysql_connect() VS msql_connect() etc.... ????

If so, that would be perfect.

But what about the general syntax in query's ????

no-no,

I just mean that most MySQL SQL statements will work in MS SQL Server.
I know only one commonly used thing that won't - LIMIT statement. MS SQL Server use TOP instead thit.

there's a big difference, even though both are based on the sql "standard"

e.g. all the date functions are different

and one thing that may require a lot of work is converting queries that have GROUP BY -- SQL Server will enforce consistency between the GROUP BY clause and all the non-aggregate columns in the SELECT