Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving results of view to file

Status
Not open for further replies.

hedgracer

Programmer
Mar 21, 2001
186
US
Can the results of a view be saved to a file directly from sql server 2005? How would this be done? Thanks for all help in advance.

Dave
 
Open a query window.
Right click in the window
Results To -> Results To File

In the query window, type:

Select * From YourViewName

Press F5


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Alternatively....

Right click your database, click asks, Click Export Data...
Follow the wizard. At some point, you'll be able to select your view.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top