>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?

The answer is yes, but you have to ask more specific questions.
For starters read the section on Client-Server in the help files.

Then look at the following sections:
SQLConnect()
SQLStringConnect()
SQLDisconnect()
SQL Pass-Through
Remote Views
Buffering