Viewing 2 posts - 1 through 3 (of 3 total)
Yes the table can be created this way because the column is not persisted. If you create it as shown below, or modify the...
August 23, 2006 at 9:05 am
#656388
Neither of the following work:
(dateadd(day,(10),convert(datetime,'1900-01-01 00:00:00.000')))
(dateadd(day,(10),cast('1900-01-01 00:00:00.000' as datetime)))
August 21, 2006 at 5:56 pm
#656028