Database Interoperability

Summary

Looking back over this chapter, you can see that there are a number of issues when writing code that’s interoperable between SQL Server and the other major database platforms. Whether you want to move code from SQL Server 2005 or to SQL Server 2005 from another database platform, you’ll likely have to change some of the code so that it can run properly. There are a number of areas where you have to be careful, from naming identifiers and choosing datatypes to writing transportable SELECT and CREATE TABLE statements. This chapter helped ease all those requirements by informing you how SQL Server implements each statement, and comparing that to how the other database platforms accomplish the same thing. Thus, you’re able to write much more interoperable and transportable code from the start.