Transact-SQL commands are executed within the utilities provided by Microsoft, as well as in third party applications that support embedded SQL. For information about writing client applications, refer to Microsoft SQL Server Programming DB-Library for C and Microsoft SQL Server Programming DB-Library for Visual Basic.
These are the utilities in which Transact-SQL statements and procedures can be executed:
| Utility | Description |
|---|---|
| isql | Provides a query interface and allows you to perform system administration tasks from a server or a workstation. Also allows scripts to be created for automating tasks. |
| ISQL/w | Allows you to enter Transact-SQL statements and system stored procedures in a graphical query interface. ISQL/w also provides a graphical way to analyze queries. |
| SQL Enterprise Manager | Provides easy, enterprise-wide management from a server or a workstation and includes the query window capabilities of the ISQL/w utility. |