Hi All,
Can someone provide the query to insert default value(1753-01-01 00:00:00.000) in datetime field if select query from other table returns null in sql server
Example:
INSERT INTO [dbo].[Test] ([time1])
SELECT c.[time2] from [dbo].[Test1] c
where [time2] allows Null values and [time1] does not allow Null values.
Thanks in advance,
Srinivas Maddula