insert into tbl_store
(
productId,
productName,
productDate
)
select @productID,@productName,case when @productDate='' then null else cast(@productDate as datetime) end
(
productId,
productName,
productDate
)
select @productID,@productName,case when @productDate='' then null else cast(@productDate as datetime) end
用你的方法,还是插入的1900-1-1
(mydate datetime)
declare @a varchar(10)
set @a=''
insert into #test select case when @a='' then null else cast(@a as datetime) endselect * from #test2005-01-31 00:00:00.000
NULL
if productDate is null
begin
insert into tbl_store
(productId,productName,)
values(@productId,@productName)
end
else
begin
insert into tbl_store
(productId,productName,productDate)
values(@productId,@productName,cast(@ProductDate as datetime))
end
(
productId int,
productName varchar(10),
productDate datetime
)declare @productid int ,@productname varchar(10),@productdate datetime
select @productid=1,@productname='asdfas',@productdate=nullinsert into tmp
(
productId,
productName,
productdate
)
select @productid,@productname,
case when @productdate is null then null else @productdate endselect * from tmp