Dec 22, 2009 #1 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
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
Dec 22, 2009 #2 gmmastros Programmer Feb 15, 2005 14,901 US 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 Upvote 0 Downvote
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
Dec 22, 2009 #3 gmmastros Programmer Feb 15, 2005 14,901 US 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 Upvote 0 Downvote
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