可以如select getdate()-如库日字段 from 表
解决方案 »
- MDX语句截取前六位字段
- 关于存储过程的简单问题,麻烦给说明一下哈
- 求sql语句?(高手帮忙)!!
- 数据库备份作业的问题
- 日志文件已经 50G了.硬盘只剩 9M了.收缩日志文件不管用,怎么办?
- 编写存储过程的时候怎么自动缩进
- 如何写这条SQL语句 门卡系统
- 有没有什么软件,或者命令能从SQL Server中把一个表的结构导成"Create table Test( name varchar(30))...."这样的脚本呢?
- 寻求奇怪SQL语句!!!!!!!!!!!!!!!!!!!!!!!!!!
- 1 sp中不能用use dbaseName,用什么可以改变当前数据库?2 sp中能改变用户名和口令吗?
- paradox7表导到mssql里出问题
- 请教: 此SQL输出结果是什么?
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]
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]