New T-SQL BULK EXPORT & BULK WRITE Statements - by Kalman Toth

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 512367 Comments
Status Resolved Workarounds
Type Suggestion Repros 0
Opened 11/19/2009 12:51:19 PM
Access Restriction Public
Primary Feedback Item 224026


Frequently data has to be exported out of the database in bulk to flat file, Excel file or other formats. Currently there is no T-SQL statement to do that. There is no equivalent of the BULK INSERT statement(import) to export data from tables, views or queries.
Sign in to post a comment.
Posted by Microsoft on 11/24/2009 at 10:03 AM
Thanks for your feedback. Ideally, the implementation Bulk EXPORT command will allow for query on the base table/view so you won't need BULK WRITE. I am resolving this as a duplicate of connect-id 224026.


Posted by AaronBertrand on 11/20/2009 at 12:42 PM
Please vote on this item:

Creating a new item just dilutes the votes. Hopefully Microsoft will close this as a duplicate and refer people to #224026.