Copying Views

The bcp utility also supports copying data out of a view. This allows you to copy specific columns, add a WHERE clause, or perform special formatting such as changing data formats using the CONVERT function.