Loading

copry varbinary datatype

Abdu Rafeeq

How to copy varbinary datas from one table to another in sqlserver2005?

i tried with a query

insert into Newtable(column list) select * from oldtable;

here some table values are varbinary, except varbianry datas are copying with this query.How to copy varbinary data?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
I think you can get help from articles in this web site.

I think that beginners usually put the data in the SQL statement but that won't work when the data is binary. So try doing a parameterized statement. If you don't know what that is then look for articles about that.