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 |
|
um.kumar2
Starting Member
3 Posts |
 Posted - 2010-01-09 : 09:50:19
|
| Hi All,This is ulagu.I need a clarification regarding BCP usage.I have written Stor Proc which will write output data file using BCP.The problem is,when I execute the entire Stor Proc statements the output file is written with 6 records and when I use "exec SPName" it creates only 4 records.Can anyone help me in this why it shows difference in output data file.Thanks,ulagu. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-09 : 09:54:43
|
Without seeing your original stored procedure we cannot see anything.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-09 : 10:09:48
|
| is there any changes in values passed for sp parameters in both cases? |
|
|
|
um.kumar2
Starting Member
3 Posts |
Posted - 2010-01-09 : 12:12:42
|
| Visakh16/webfredI have used no Parameters actully...and i could not paste actual SP immediately.I just wanted to know if it is generic problem.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-09 : 12:19:56
|
quote:
Originally posted by um.kumar2
Visakh16/webfredI have used no Parameters actully...and i could not paste actual SP immediately.I just wanted to know if it is generic problem..
without have enough information its difficult to tell what exactly the problem is. can you post at least bcp line? |
|
|
|
um.kumar2
Starting Member
3 Posts |
Posted - 2010-01-09 : 12:28:14
|
| Will do it later..Thanks for ur reply... |
|
|
|
|
|
|
BCP problem