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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2007-12-04 : 06:35:08
|
| How do I create a text file with fixed length fields from a SQL table using a stored procedure. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-04 : 06:39:43
|
| using bcp?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-04 : 06:39:57
|
You pad extra leading or trailing spaces.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-12-04 : 08:57:15
|
| Are there any beginners examples of bcp in a stored procedure ? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-04 : 09:02:11
|
| http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
Fixed length text field