Select ... Union 是不能用关键字Default的,可以参考:use tempdb go if object_id('#1') is not null Drop Table #1 Create Table #1(id int,LastUpdateDate datetime Default(getdate())) --1 Insert #1(ID,LastUpdateDate) values(1,default),(2,getdate()),(3,'2012-2-19 12:00') --2 Insert #1(ID) Select 4 union All Select 5 union All Select 6
go
if object_id('#1') is not null Drop Table #1
Create Table #1(id int,LastUpdateDate datetime Default(getdate()))
--1
Insert #1(ID,LastUpdateDate) values(1,default),(2,getdate()),(3,'2012-2-19 12:00')
--2
Insert #1(ID)
Select 4 union All
Select 5 union All
Select 6