How to get around openquery defaulting columns to not null.

Question

I have a sql server pass-thru query like this:

*select * into myTable from openquery (yourComputer, 'select x,y,z, from yourTable')*

The problem is the columns in myTable are defaulting to not null and I will later want to add rows to this table with some columns null.

Can I get round this?

Answer 1

you could insert the results into a temp table and then update the table to set all null values to '', then insert the values in the temp table to the actual table

Answer 2

Create myTable before inserting data, then perform insert.

create table myTable (
    x int null,
    y int null,
    z int null
)
go
insert into myTable (x, y, z)
select x, y, z
from openquery (yourComputer, 'select x,y,z, from yourTable')