Copy data from table to another table

Question

I have two tables, the main one is called [dettaglioMateriale]

the second is called [fuoriUso]

through a button I have to copy two columns of the relevant row from the main one to the second one

the colums are IDdettaglio and Note tbl[dettaglioMateriale] , in CODdettaglio and Note tbl[fuoriUso]

the button code that calls two stored procedures is this

the first stored procedure deletes associations to other tables, and works fine

the second stored procedure copies the columns from the first table to the second

I get the following error, as in the table where the columns are copied there is the Distrutto column (bit) which is a checkboxfield and does not allow null fields

how can i solve the problem?
I also thought about doing an additional INSERT and giving the value FALSE as the default (which would also be right), but I couldn't.

thanks in advance to those who want to help me.

Answer 1

Try this INSERT statement:

INSERT INTO [dbo].[fuoriUso] ( CODdettaglio, Note, Distrutto )
SELECT IDdettaglio, Note, 0
FROM . . .

It is probably better to adjust the table definition, adding the default value for Distrutto column:

alter table [dbo].[fuoriUso] add constraint somename1 default 0 for Distrutto