/*
   2017. október 25., szerda16:24:13
   User: sa
   Server: 192.168.58.1,1450
   Database: _f_aruker
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_renf ADD
	raktar_kod dbo.kulcs NULL
GO
ALTER TABLE dbo.vevo_renf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go


update vevo_renf set raktar_kod=0
go


BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.nb_vevo_renf ADD
	raktar_kod dbo.kulcs NULL
GO
ALTER TABLE dbo.nb_vevo_renf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go


update nb_vevo_renf set raktar_kod=0
go


insert into verzio values('upg','Ver. 2.47', dbo.mygetdatetime())
go