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 - 2001-02-28 : 23:56:19
|
Mala writes "Hi,
How do I read data in text file in the SP. My task is, I have record details stored as below in text file.
adc,dff,1,344,fdfd
abd,fdf,2,444,dflf
I have already written SP which can seperate above recordset passed as one string and write it on table. But I have to first read it from the text file. Please help me how can read it in SP.
It has to be something like this.
My Sp to read one set of record/string from text file.
Pass this string to my another SP which will seperate fields and write it on table[which is already ready]
Then fetch next set of recrod/string from text file.
Thanks in advance.
Bye,
Mala" |
|
|
|
|
|
Stored Procedure