创建表时列默认值怎么引用其他列的值？

[TheGodOfGods]

rt，有如下表tb，time1为时间类型，time2为varchar类型，截取time1的日期部分，我想通过在time2的default值里边调用相应处理函数，怎么把time1当参数传入？

if object_id('tb') is not null
	drop table tb
create table tb(ID int, time1 datetime not null default (getdate()),
time2 varchar(10) default (dbo.GetShortTime(time1))) 

相应函数为

IF OBJECT_ID (N'dbo.GetShortTime', N'FN') IS NOT NULL
    DROP FUNCTION dbo.GetShortTime;
GO
create function dbo.GetShortTime(@date datetime)
returns varchar(10)
AS
BEGIN
return CONVERT(varchar(10),getdate(), 120)
END

[SQLCenter]

create table tb(ID int, time1 datetime not null default (getdate()),
time2 as CONVERT(varchar(10),time1, 120)
)

[coleling]

--使用计算列,用AS关键字
if object_id('tb') is not null
drop table tb
create table tb(ID int, time1 datetime not null default (getdate()),
time2 AS dbo.GetShortTime(time1))

[TheGodOfGods]

正解