?? valid.sql
字號:
CREATE VIEW dbo.Valid
AS
SELECT dbo.ProInStore.StoreProId AS 倉庫存儲編號, dbo.Product.ProName AS 產品名稱,
dbo.ProInStore.ProPrice AS 產品價格, dbo.ProInStore.ProNum AS 產品數量,
dbo.ProInStore.CreateDate AS 生產日期, dbo.Storehouse.StoreName AS 倉庫名稱,
ROUND(DATEDIFF(day, DATEADD(day, dbo.Product.Valid, dbo.ProInStore.CreateDate),
GETDATE()), 0) AS 距離失效期的天數
FROM dbo.ProInStore INNER JOIN
dbo.Product ON dbo.ProInStore.ProId = dbo.Product.ProId AND DATEDIFF(day,
GETDATE(), dbo.ProInStore.CreateDate)
>= dbo.Product.Valid - dbo.Product.AlarmDays INNER JOIN
dbo.Storehouse ON dbo.ProInStore.StoreId = dbo.Storehouse.StoreId
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -