I have two tables a and b with columns in them, say a.test1 and b.test2, which are both ntext. I've done a lot of reading online about UPDATETEXT and WRITETEXT but I don't have enough experience to really understand it. I just want to copy whats in a.test and insert it into b.test. I don't have any code because I still don't understand enough about how to go about doing this. Also whatever I write has to also work in Oracle!!!
If only it was as easy as:
- insert into b (test2) select test1 from a
but I get an error because it's ntext.