Will JDBC handle the differences betweeen, for example, the way records are "auto-incremented" between MySQL and SQL Server? For example, if you have code that MySQL likes, you'd have something like: Insert into table (Field1, field2) VALUES (null, <somevalue> However, in SQL Server, the syntax is different. So what I'm asking is whether JDBC will translate the insert statement that you wrote for MySQL so that it will work (without any modifications other than using the SQL Server Driver) with SQL Server? Thanks very much in advance! -- Mike
Yes and No. MySQL, with the exception of specialized functions, adheres strictly to ANSI SQL. So no problems there. MS SQL should adhere to ANSI SQL, and when you say the MS SQL version of that statement is different, I would say that it should still work. However, MS SQL also uses a query language called TSQL (Trasact SQL). So there are some SQL Statements that will work in MS SQL that won't work in MySQL. Also, MS SQL has specialized functions just as MySQL does. So I say yes, because the same SQL statements, short of special functions, should cary over from MySQL to MS SQL. But no, because the opposit won't always hold true if using TSQL.