sql 数据类型转换

最新推荐文章于 2024-10-29 11:58:51 发布

原创最新推荐文章于 2024-10-29 11:58:51 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

SELECT     IdAss, AssetSn, AssetName, AssetEnglish, Model, BrandAssets, NowNum, BarCode, SuppSn, TypeSn, PartId, Buyid, Deprecion, AssetConfig,
                      ServiceTime, AssetPrice, AssetUnit, AssetStatus, EmpSn, MakeDate, getAssetDate, UseDate, AssetTracking, BuySn, WarrantyNum, Remarks, JLsn,
                      AllonSN, BadType, AssetUseSn, DepartMentSn, AssetSource, StorSn, UserMan, RZDate, tradType, SaveAdrees, TagRemark, Salvage, life, InputMan,
                      EditTime, EditMan, passStatus
FROM         dbo.AssetInfo
WHERE     (life * 365 - (GETDATE() - UseDate) <=
                          (SELECT     CONVERT(int, NumbersRole) AS dateNumbers
                            FROM          dbo.Ment
                            WHERE      (Type = 4)))

注意转换 CONVERT(int, NumbersRole)