ENTEGRE GÜNCELLEME 
1 - 2021 01  VERS YÜKLEYİP DB GÜNCELLEYELİM.
2- AŞAGIDAKİ SORGULARI ÇALIŞTIRALIM.
3- SON VERS YÜKLEYELİM. DB GÜNCELLEYELİM.
GO
select top 5 * from Parametre WHERE Param LIKE 'OS%'
UPDATE Parametre SET Deger ='C:\Program Files\Microsoft SQL Server\150\Tools\Binn\OSQL.EXE' WHERE Param LIKE 'OS%'

GO
DELETE FROM GridView
GO
ALTER TABLE [dbo].[ACIKLAMA] DROP CONSTRAINT [PK_ACIKLAMA] WITH ( ONLINE = OFF )
GO

SELECT TOP 1 * FROM CariFiyatlari
SELECT TOP 1 * FROM ACARI 
ALTER TABLE ACARI DROP COLUMN DovizBakiye
ALTER TABLE STOKHARDETBAG ADD FaturaTipi INT NULL
SELECT * FROM Odeme

--ENTEGRE 5'DEN (2020_1.AY İÇİN)
alter table Kullanicilar drop column IYTED
GO
alter table Kullanicilar drop column IYTSD
GO
--
declare @CNTNAME NVARCHAR(100),@SQL NVARCHAR(MAX)
select @CNTNAME=name from sys.default_constraints where name like 'DF__ACARI__DovizBaki%'
SET @SQL='ALTER TABLE [dbo].[ACARI] DROP CONSTRAINT ['+ CONVERT(VARCHAR(100),@CNTNAME)+']'
EXEC(@SQL)
ALTER TABLE [dbo].[ACARI] drop column [DovizBakiye]

go

alter table Kullanicilar drop column IYTED
GO
alter table Kullanicilar drop column IYTSD
GO 
 
    
   alter table CariFiyatlari add AlisFiyatiH varchar(20),SatisFiyatiH varchar(20)
--go


alter table KullaniciVarsayilanRaporlari drop column OnIzleme
go
alter table KullaniciVarsayilanRaporlari drop column RaporSecimOnIzleme
go
alter table KullaniciVarsayilanRaporlari drop column Yazici
go
ALTER TABLE ACARI DROP COLUMN DovizBakiye
GO
ALTER TABLE STOKHARDETBAG ADD FaturaTipi INT NULL
GO
 
CREATE TABLE [dbo].[EF_SABIT](
	[KULLANICI_ADI] [varchar](100) NULL,
	[KULLANICI_PAROLA] [varchar](20) NULL,
	[FATURA_EK] [varchar](20) NULL,
	[ARSIV_EK] [varchar](20) NULL,
	[MAIL_ADRES] [varchar](50) NULL,
	[FATURA_ON_EK] [varchar](20) NULL,
	[ARSIV_ON_EK] [varchar](20) NULL,
	[AD] [varchar](50) NULL,
	[SOYAD] [varchar](50) NULL,
	[ACIKLAMA] [varchar](1000) NULL,
	[ACIKLAMA2] [varchar](1000) NULL,
	[ACIKLAMA3] [varchar](1000) NULL,
	[IBAN] [varchar](1000) NULL,
	[IRSALIYE_EK] [varchar](20) NULL,
	[IRSALIYE_ON_EK] [varchar](20) NULL,
	[ACIKLAMA1] [varchar](1000) NULL
) ON [PRIMARY]
GO