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 - 2003-07-31 : 08:34:20
|
| Stephen writes "Hi,Does anyone know why I get the following error "Server: Msg 170, Level 15, State 1, Line 8Line 8: Incorrect syntax near '@MyTableVariable'." when I run a BULKINSERT into a table variable. If I change the table variable to a # table, it works fine.Tnx for your help." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-31 : 08:36:05
|
| Because you can't BULK INSERT into a table variable. You can with a temp table.Table variables are not always the best method to use, nor should you assume that temp tables are bad. |
 |
|
|
|
|
|
Table Variable and BULKINSERT