Transact-SQL is the version of ANSI SQL-92 (plus enhancements) which

MS SQL-Server supports. The enhancements to ANSI SQL are usually

things like date handling functions.

Examples of VFP functions which are not supported by SQL Server are

INLIST (use IN ( , , ,) )

DTOC (use CAST)

In other words, for most VFP functions there is a corresponding SQL

function, but they do not always have the same name or function

exactly the same way.

It's important to know the differences when writing a SELECT statement

against Fox tables which may eventually be migrated to an SQL

database.

Other SQL databases like Oracle have different enhancements to the

SQL-92 standard.

Cindy Winegarden

Microsoft Certified Professional, Visual FoxPro

Duke Children's Information Systems

Duke University Medical Center

cindyw@duke.edu

----- Original Message -----

From: <Gregoryagu@aol.com>

To: "Multiple recipients of ProFox" <profox@leafe.com>

Sent: Sunday, July 02, 2000 9:51 PM

Subject: Transact-SQL

|

| Can someone tell me what "Transact-SQL" is, as in the following:

|

| 'Although VFP and Transact-SQL have some functions in common, many

VFP

| functions aren't supported by SQL Server.'

|

|

|

| Gregory A. Gum

| Dallas Texas

|

|

| ----------------------------------------

| Subscription maintenance at:

| http://leafe.com/mailListMaint.html

|

|

|

|