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 |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2005-09-29 : 17:39:49
|
| Hi All,I'm wondering whether its possible to insert values to multiple tables from a deimted text file stored in a text data type column of a table?If its a plain text file in hard disk i would had used dts, now I'm not sure...Any pointers?Karunakaran |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-29 : 19:22:29
|
| I think that the SUBSTRING function works with TEXT(only have BOl-2005 on this machine)Is it fixed-lenght delimited, or delimited with some character(,;) ?>> If its a plain text file in hard disk i would had used dts, now I'm not sure...or BULK INSERT, or bcp. |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-09-30 : 00:22:21
|
| Its delimted with tab.Karunakaran |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-30 : 01:03:17
|
| "I think that the SUBSTRING function works with TEXT"Yes it does.There's an article or thread on splitting TEXT datatype somewhere on SQLTeam, but I'm blowed if I can find it.Kristen |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-09-30 : 02:35:49
|
| Can I use bcp to get only a specific column of a specific row in a table?Karunakaran |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
text column to different tables.