这个视图该怎么改？

[csutzs]

现有视图的代码如下，我想加在视图里加个字段，表示在库日，是由当前时间减去入库时间（TSTOCK表里有该字段）得到，
请问可以修改这个视图办到么？

SELECT dbo.TStock.*, dbo.tDepartment.Name AS NameWarehouse,
dbo.tMerchandise.Code AS CodeMerch, dbo.tMerchandise.Name AS NameMerch,
dbo.tMerchUnit.Unit AS NameUnit, dbo.tWareDist.Name AS NameWareDist,
dbo.tMerchandise.Spec AS Spec, dbo.tSupplier.Name AS NameSupply,
dbo.tMerchandise.KeyMerchType AS KeyMerchType
FROM dbo.TStock LEFT OUTER JOIN
dbo.tDepartment ON
dbo.TStock.KeyWarehouse = dbo.tDepartment.[Key] LEFT OUTER JOIN
dbo.tMerchandise ON
dbo.TStock.KeyMerch = dbo.tMerchandise.[Key] LEFT OUTER JOIN
dbo.tMerchUnit ON dbo.TStock.KeyUnit = dbo.tMerchUnit.[Key] LEFT OUTER JOIN
dbo.tWareDist ON dbo.TStock.KeyWareDist = dbo.tWareDist.[Key] LEFT OUTER JOIN
dbo.tSupplier ON dbo.TStock.KeySupply = dbo.tSupplier.[Key]

[daijingjie2002]

可以如select getdate()-如库日字段 from 表

[pbsql]

select 在库日=datediff(day,入库时间,getdate()) from TSTOCK

[sdhdy]

SELECT dbo.TStock.*, dbo.tDepartment.Name AS NameWarehouse,
dbo.tMerchandise.Code AS CodeMerch, dbo.tMerchandise.Name AS NameMerch,
dbo.tMerchUnit.Unit AS NameUnit, dbo.tWareDist.Name AS NameWareDist,
dbo.tMerchandise.Spec AS Spec, dbo.tSupplier.Name AS NameSupply,
dbo.tMerchandise.KeyMerchType AS KeyMerchType,datediff(dd,TStock.入库时间,getdate()) 在库日--add
FROM dbo.TStock LEFT OUTER JOIN
dbo.tDepartment ON
dbo.TStock.KeyWarehouse = dbo.tDepartment.[Key] LEFT OUTER JOIN
dbo.tMerchandise ON
dbo.TStock.KeyMerch = dbo.tMerchandise.[Key] LEFT OUTER JOIN
dbo.tMerchUnit ON dbo.TStock.KeyUnit = dbo.tMerchUnit.[Key] LEFT OUTER JOIN
dbo.tWareDist ON dbo.TStock.KeyWareDist = dbo.tWareDist.[Key] LEFT OUTER JOIN
dbo.tSupplier ON dbo.TStock.KeySupply = dbo.tSupplier.[Key]

[daijingjie2002]

SELECT dbo.TStock.*, dbo.tDepartment.Name AS NameWarehouse,
dbo.tMerchandise.Code AS CodeMerch, dbo.tMerchandise.Name AS NameMerch,
dbo.tMerchUnit.Unit AS NameUnit, dbo.tWareDist.Name AS NameWareDist,
dbo.tMerchandise.Spec AS Spec, dbo.tSupplier.Name AS NameSupply,
dbo.tMerchandise.KeyMerchType AS KeyMerchType,
getdate-日期字段 as 在库时间
FROM dbo.TStock LEFT OUTER JOIN
dbo.tDepartment ON
dbo.TStock.KeyWarehouse = dbo.tDepartment.[Key] LEFT OUTER JOIN
dbo.tMerchandise ON
dbo.TStock.KeyMerch = dbo.tMerchandise.[Key] LEFT OUTER JOIN
dbo.tMerchUnit ON dbo.TStock.KeyUnit = dbo.tMerchUnit.[Key] LEFT OUTER JOIN
dbo.tWareDist ON dbo.TStock.KeyWareDist = dbo.tWareDist.[Key] LEFT OUTER JOIN
dbo.tSupplier ON dbo.TStock.KeySupply = dbo.tSupplier.[Key]