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.




Inside SQL Server 2005 Tools
Inside SQL Server 2005 Tools
ISBN: 0321397967
EAN: 2147483647
Year: 2006
Pages: 149

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net