tags:

views:

84

answers:

3

can you run ansi sql statements in sql server express 2005 or 2008?

+3  A: 

Sql Server understands Ansi Sql. However there are always different interpretations of the standards. Here is an article that I found that lists some of the differences: Think ANSI Standard SQL Is Fully Portable Between Databases? Think Again.

Brian
A: 

very helpful-thanks!

luc
A: 

If you are only using SQL Server backends for your product, forget about ANSII sql, T-SQL has much more efficient and effective ways of querying a SQL Server database. ANSII is ok if you have to have a multiple backends, but if you don't it is stupid to limit yourself to the least effective code available. This is true of any database backend, the proprietary language for that database is designed to run better than anything else.

But in answer to your question, yes some of the ANSII standard works and some of it does not. For any basic queries you may be ok, it is the complex stuff which tends to really point out the differences. So basically you can't get out of testing it all. Which you should be doing anyway.

HLGEM