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 - 2006-05-10 : 08:08:03
|
| khushboo writes "when i use the statement SET @SQL = "BULK INSERT TmpStLst FROM 'c:\dnc\input\TxtFile1.txt' WITH (FIELDTERMINATOR = '"",""')"it gives me an error .Can you help me how to use bulk insert." |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-05-10 : 08:29:24
|
| what error it shows?have u declare the variable '@SQL'?BMahesh |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-10 : 08:46:22
|
| Look for Bulk insert in sql server help file for the correct syntaxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
query