sql-generate-insert
sql-generate-insert copied to clipboard
datetime columns conversion
problem: extra size/performance issues due to convert for datetime
solution explicit conversion for date or datetime is unnecessary, instead of convert(datetime,'2020-01-01 00:00',121) , there should be just '2020-01-01 00:00'. sql server does perfect job in converting datetime if value strings are in sql server date format