这适用于sql Server 2008
create table dbo.Foo
(
StartDate int,
CallDT AS (CONVERT([datetime],dateadd(second,[StartDate],'01/01/1970'),(0)))
)
select deFinition
from sys.computed_columns
where name='CallDT' and object_id=object_id('dbo.Foo')
SQL Server:是否可以从数据库检索计算列定义?
这适用于sql Server 2008
create table dbo.Foo
(
StartDate int,
CallDT AS (CONVERT([datetime],dateadd(second,[StartDate],'01/01/1970'),(0)))
)
select deFinition
from sys.computed_columns
where name='CallDT' and object_id=object_id('dbo.Foo')