Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-15 : 08:00:35
|
| Gauri writes "Q1.Is it possible to export each record in Sql to separate text files?Q2. If I write a stored procedure to export the Data can I concatenate some text to the fields?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-15 : 08:02:38
|
| 1. Yes, but it would be impractical for tables containing thousands of rows.2. Yes. Using bcp or DTS would be better for this, you don't need stored procedures to use either.Describing your situation in more detail will make it easier for us to provide a solution. |
 |
|
|
|
|
|
Data Export