Inserting missing date into non nullable Datetime field

Advertisements Here we have an existing database and I’m building a new system with a new database. There I need to transfer some data from the old database table to the new database table. I wrote this query in the SQL INSERT INTO [Mondo-UAT].[dbo].[Countries] ( [Country_Name] ,[Country_Code] ,[Note] ) SELECT [Code1] ,[Code3] ,[Name] FROM [MondoErp-UAT].[dbo].[Nations]… Read More Inserting missing date into non nullable Datetime field