Question about SQL

[KodoSan]

Just a general observation. Since connection strings determine what driver is used to connect to a database.. is SQL pretty much the same throughout the different DB types..
i.e can I use my ASP code that I use to connect to a MS SQL 7 server and just change the conn driver and use it for a mySQL server for instance?
Thanks

 

[foxbox]

in general: yes.
but some special tricks may not supported. like
SELECT @@IDENTITY and stored procedures:

http://www.mysql.com/doc/T/O/TODO.html

br
Gerard