-
Insert into temp table with Union All in SQL
If you are trying to insert all records from multiple tables to one temp table, the following codes may help.…
-
SQL Zero Date Time
Someone may need to use Zero Date instead of null with datetime datatype SELECT CONVERT(DATETIME,’1900–01–01 00:00:00.000′) Return Result: 1900-01-01 00:00:00.000
