Chapter 5. Inside Data Authoring Tools

This chapter covers Query Editor as the main part of SQL Server Management Studio's data authoring environment and Bulk Copy Utility (BCP), which allows you to move data between different data sources.

Query Editor in SQL Server 2005, in addition to T-SQL, enables you to edit XML, as well as MDX, DMX, and XMLA queries. This integration is made possible via SQL Server Management Studio's integration with Visual Studio's development environment framework. A few improvements, which have been made specifically to retrieval and display of results in Query Editor, are also covered in this chapter.

Bulk Copy Utility has existed since the first release of the product. The entire feature will be covered thoroughly in this chapter, as well as new improvements made to BCP for the SQL Server 2005 release, such as support of new file formats, the XML data type, and security enhancements.