M
Marshall Smith
OK, Books Online is taking me in directions that I don't think I want to go
on this question.
I'm in the middle of redesigning a database. I want to move all the data
from one table into a different table, matching it up by primary key.
Everything works well, except for updating the columns with type text. I'm
trying to use a stored procedure that looks like:
UPDATE NewTable
SET NewTable.NewText =
(SELECT OldTable.OldText
FROM OldTable
WHERE OldTable.PrimaryKey = NewTable.PrimaryKey)
I'm getting datatype errors. My guess is that it doesn't want to move the
pointers over. What would be a proper way to handle this?
on this question.
I'm in the middle of redesigning a database. I want to move all the data
from one table into a different table, matching it up by primary key.
Everything works well, except for updating the columns with type text. I'm
trying to use a stored procedure that looks like:
UPDATE NewTable
SET NewTable.NewText =
(SELECT OldTable.OldText
FROM OldTable
WHERE OldTable.PrimaryKey = NewTable.PrimaryKey)
I'm getting datatype errors. My guess is that it doesn't want to move the
pointers over. What would be a proper way to handle this?