>Can someone help me with SQL syntax, commands, and procedures, using VFP 6.0 to add databases, tables, and access to them on SQL server?

Like Alex said, you'll need to ask questions that are much more specific. In addition to the Help topics Alex pointed out, you might benefit from reading "Client-Server Applications with Visual FoxPro and SQL Server 7.0" from http://www.hentzenwerke.com/catalogpricelists/csvfp.htm.