>I've got an upcoming project that is heavily SQL Server. I know that the SQL commands are "supposed" to be standard, but every vendor has their own extensions. Back in the eighties, I worked with Oracle and Informix, and I know enough that whatever it is I wanted to do in Oracle seemed better suited for the Informix extensions, and vice versa.
>
>Now that I've been totally immersed in VFP's version for years, I'm wondering what I'm going to miss in VFP's syntax when I leap into SQL Server. Likewise, what am I going to find out about in SQL Server that you can't do in VFP? Do any of you have any words of wisdom on the differences between the SQL dialects?
>
>Thanks,
>
> - della

Probably you won't miss anything from the VFP dialect. Most likely you will need to make slight modifications on the syntax for data definition statements (DDL), and data manipulation statements (DML) are similar for the most part.

There are a number of things that you don't find in VFP, one example being multiple row inserts, or the ability to have a select statement specified in the values portion of an INSERT statement.

One piece of knowledge that ports nicely is the one on query optimization, your "Rushmore optimizable" SQL statements will also be optimized by SQL7 (for the most part) I wonder where they got this idea? Certainly FP predates SQL Server, I don't know when Rushmore came to be on FP.

Just my .02