Microsoft® Visual Studio® includes the major Microsoft development systems: Microsoft Visual Basic®, Microsoft Visual C++®, Microsoft Visual J++™, Microsoft Visual InterDev™, and Microsoft Visual FoxPro®. These products are also available separately.
These development systems support the development of Microsoft Windows® and Web-based applications. Microsoft SQL Server™ supports the database APIs used by these and other languages when building applications that store their data in a database: ADO, OLE DB, ODBC, Embedded SQL, and legacy APIs such as DB-Library.
In addition to being familiar with the use of Transact-SQL, programmers must understand how the database API they are using interacts with Transact-SQL. They must understand how to supply data values for parameters and how to move the data values in a result set into variables in their applications.