B Formu Ile Ilgili Degisiklik

ALTER TABLE TBLBFORMMAS ADD OTICSICILNO VARCHAR(15)
GO
ALTER TABLE TBLBFORMMAS ADD OEPOSTA VARCHAR(30)
GO
ALTER TABLE TBLBFORMMAS ADD OALANKOD VARCHAR(8)
GO
ALTER TABLE TBLBFORMMAS ADD OTELNO VARCHAR(10)
GO
ALTER TABLE TBLBFORMMAS ADD MTICSICILNO VARCHAR(15)
GO
ALTER TABLE TBLBFORMMAS ADD MEPOSTA VARCHAR(30)
GO
ALTER TABLE TBLBFORMMAS ADD MALANKOD VARCHAR(8)
GO
ALTER TABLE TBLBFORMMAS ADD MTELNO VARCHAR(10)
GO
ALTER TABLE TBLBFORMMAS ADD HTICSICILNO VARCHAR(15)
GO
ALTER TABLE TBLBFORMMAS ADD HEPOSTA VARCHAR(30)
GO
ALTER TABLE TBLBFORMMAS ADD HALANKOD VARCHAR(8)
GO
ALTER TABLE TBLBFORMMAS ADD HTELNO VARCHAR(10)
GO
DROP VIEW BFORMMAS
GO
CREATE VIEW BFORMMAS AS
SELECT TBLBFORMMAS.*
FROM TBLBFORMMAS With(NoLock), NetContext
WHERE ((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU)))
GO
CREATE TRIGGER BFORMMAS_TRG ON BFORMMAS INSTEAD OF DELETE
 AS
 BEGIN
 DELETE FROM TBLBFORMMAS
 FROM DELETED WHERE
 (DELETED.ISLETME_KODU = TBLBFORMMAS.ISLETME_KODU)
 END
GO
ALTER TABLE TBLBFORMU ADD TCKIMLIKNO VARCHAR(15)
GO
DROP VIEW BFORMU
GO
CREATE VIEW BFORMU AS
SELECT TBLBFORMU.*
FROM TBLBFORMU With(NoLock), NetContext
WHERE ((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU)))
GO
CREATE TRIGGER BFORMU_TRG ON BFORMU INSTEAD OF DELETE
 AS
 BEGIN
 DELETE FROM TBLBFORMU
 FROM DELETED WHERE
 (DELETED.ISLETME_KODU = TBLBFORMU.ISLETME_KODU)
AND
 (DELETED.INCKEYNO = TBLBFORMU.INCKEYNO)
 END