Copy SQL Server table records into a text file?

Question

How to copy all records of one table from a SQL Server database into a text file? I need to send one table records to another person, how can I do it

did you get a chance to look at this link http://stackoverflow.com/questions/17781896/need-help-to-export-table-from-sql-server-2008-to-text-file — Satya, Apr 26 '17 at 05:05

score 1 · Answer 1 · answered Apr 26 '17 at 05:16

1

Just setup the option of "results to text" (Hit Ctrl + T) Or "results to file "(Ctrl +shift + f)

answered Apr 26 '17 at 05:16

Hila DG

688
4
12

ishan joshi · Accepted Answer · 2017-04-26T12:59:32.667

0

if you want to give data to another person then create backup(with data/without data or only schema) or create script then shared to that person else you can export to excel also

edited Apr 26 '17 at 12:59

answered Apr 26 '17 at 05:14

ishan joshi

270
3
13

Here is the [link](http://stackoverflow.com/questions/2321052/how-to-get-script-of-sql-server-data) – Dilip Kumar Apr 26 '17 at 12:06

Copy SQL Server table records into a text file?

2 Answers2