SQL Server Tools

SQL Server Query Analyzer and the osql utility support using Transact-SQL interactively to access and change data, and the bcp utility can be used to quickly insert large numbers of new rows into a table.

SQL Server Query Analyzer and osql are used to:

• Execute one or more Transact-SQL statements.
• Either display the results of a query to the user, or save the results in a text file.

SQL Server Query Analyzer and osql cannot:

• Key in and execute a Transact-SQL statement.
• Save a value returned by the first Transact-SQL statement.
• Key in a new Transact-SQL statement that uses the stored data value from the first query.