select null as testdate into #temp_table

Question

Hi All,

Is there a way to insert/update a datetime value (getdate()) into a temp table created like the following:

select id, null as testdate
into #temp_table

and then later statement:

update #temp_table 
set testdate=getdate()

i get error: "cannot convert datetime into int..."

Thanks, rod.

Answer 1

Cast the column in the select into

select id, cast(null as datetime) as testdate
into #temp_table