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 |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2007-11-19 : 14:51:32
|
| Hi everyone,We have a table that stores information in a blob field,and we have an archival table.We need to copy the blob from one table to anothertable....is this possible in a stored procedure?thankstony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-19 : 14:55:17
|
| Do you get an error when you run INSERT INTO/SELECT FROM?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-19 : 16:16:48
|
| The text, ntext, and image data types are invalid for local variables. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-19 : 16:22:09
|
| Why are you using a local variable?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-20 : 09:22:34
|
| We are copying from one table to another within a stored procedure |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-20 : 09:31:25
|
| You dont need to use variables for thatINSERT INTO T1 (...) select ... from T2 |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-20 : 11:06:56
|
| We will try that....I think we were trying the select into, instead of insert into |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 17:18:00
|
| Select into is used to create new table. |
|
|
|
|
|
|
Copy blobs between tables