copry varbinary datatype

Question

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?

Sam Hobbs · Answer

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.