Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in its Adaptive Server Enterprise, the successor to Sybase SQL Server.

Transact-SQL enhances SQL with these additional features:

* Control-of-flow language
* Local variables
* Various support functions for string processing, date processing, mathematics, etc.
* Improvements [citation needed] to DELETE and UPDATE statements.

Visual Studio 97

Microsoft first released Visual Studio in 1997, bundling many of its programming tools together for the first time. Visual Studio 97 was released in two editions, Professional and Enterprise. It included Visual Basic 5.0 and Visual C++ 5.0, primarily for Windows programming; Visual J++ 1.1 for Java and Windows programming; and Visual Fox Pro 5.0 for database, specifically x Base programming. It introduced Visual Inter Dev for creating dynamically generated web sites using Active Server Pages. A snapshot of the Microsoft Developer Network library was also included.

Visual Studio 97 was Microsoft's first attempt at using the same development environment for multiple languages. Visual C++, Visual J++, Inter Dev, and the MSDN Library all used one environment, called Developer Studio. Visual Basic and Visual Fox Pro used separate environments.

Microsoft Visual Studio

Microsoft Visual Studio is an Integrated Development Environment (IDE) from Microsoft. It can be used to develop console and Graphical user interface applications along with Windows Forms applications, web sites, web applications, and web services in both native code together with managed code for all platforms supported by Microsoft Windows, Windows Mobile, Windows CE, .NET Framework, .NET Compact Framework and Microsoft Silver light.

Visual Studio includes a code editor supporting IntelliSense as well as code re factoring. The integrated debugger works both as a source-level debugger and a machine-level debugger.