34,575
社区成员
发帖
与我相关
我的任务
分享
IF not EXISTS (select * from sysobjects where xtype= 'V 'and name= 'V_CH_GoodsWasteBook')
Create View V_CH_GoodsWasteBook
AS
SELECT rm.*,
rd.GoodsID,
rd.Unit, rd.Quantity, rd.Price, rd.Money,
rd.PurchaseUnit, rd.PurchaseQuantity, rd.PurchasePrice, rd.PurchaseMoney,
rd.GoodsModelID, rd.WasteQuantity, rd.WasteMoney
FROM CH_ReceiptDetail rd INNER JOIN CH_ReceiptMaster rm ON rd.ReceiptID = rm.ReceiptID
IF not EXISTS (select * from sysobjects where xtype= 'V 'and name= 'V_CH_GoodsWasteBook')
begin
declare @r varchar(1000)
select @r = ' SELECT rm.*,
rd.GoodsID,
rd.Unit, rd.Quantity, rd.Price, rd.Money,
rd.PurchaseUnit, rd.PurchaseQuantity, rd.PurchasePrice, rd.PurchaseMoney,
rd.GoodsModelID, rd.WasteQuantity, rd.WasteMoney
FROM CH_ReceiptDetail rd INNER JOIN CH_ReceiptMaster rm ON rd.ReceiptID = rm.ReceiptID'
exec(@r)
end
if exists(select 1 from sysobjects where xtype= 'V'and id=object_id(N'V_CH_GoodsWasteBook'))
drop view V_CH_GoodsWasteBook
go
Create View V_CH_GoodsWasteBook
AS
SELECT *
from ....
where ....
IF not EXISTS (select * from sysobjects where xtype= 'V 'and name= 'V_CH_GoodsWasteBook')
go
Create View V_CH_GoodsWasteBook
AS
SELECT rm.*,
rd.GoodsID,
rd.Unit, rd.Quantity, rd.Price, rd.Money,
rd.PurchaseUnit, rd.PurchaseQuantity, rd.PurchasePrice, rd.PurchaseMoney,
rd.GoodsModelID, rd.WasteQuantity, rd.WasteMoney
FROM CH_ReceiptDetail rd INNER JOIN CH_ReceiptMaster rm ON rd.ReceiptID = rm.ReceiptID