Home Dashboard Directory Help

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


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


14
0
Sign in
to vote
Type: Suggestion
ID: 512367
Opened: 11/19/2009 12:51:19 PM
Access Restriction: Public
Primary Feedback Item: 224026
0
Workaround(s)
view

Description

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.
Details
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.

Sunil

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

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=224026

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