CODEWITHSUNDEEP
sql-server-2012
Dilip Kumar
Dilip Kumar

Reputation: 15

Copy SQL Server table records into a text file?

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

Upvotes: 0

Views: 605

Answers (2)

ishan joshi
ishan joshi

Reputation: 270

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

Upvotes: 0

Hila DG
Hila DG

Reputation: 718

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

Upvotes: 1

Related Questions