/*
   2015. augusztus 10.12:44:05
   User: sa
   Server: 192.168.59.120,1450
   Database: 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.kivett ADD
	AFA_KULCS varchar(2) NULL,
	EGYSEG_AR dbo.egyseg_ar NULL
GO
ALTER TABLE dbo.kivett SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go


update kivett set afa_kulcs=
(select afa_kulcs from cikkek where cikkek.cikk_szam=kivett.cikk_szam)
go


update kivett set egyseg_ar=0
go