/*
   2015. október 29.12:46:52
   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
CREATE TABLE dbo.Tmp_havi_keszlet
	(
	datum dbo.datum NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	egyseg_ar dbo.egyseg_ar NOT NULL,
	darab dbo.mennyiseg NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_havi_keszlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.havi_keszlet)
	 EXEC('INSERT INTO dbo.Tmp_havi_keszlet (datum, raktar_kod, cikk_szam, egyseg_ar, darab)
		SELECT datum, raktar_kod, cikk_szam, egyseg_ar, darab FROM dbo.havi_keszlet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.havi_keszlet
GO
EXECUTE sp_rename N'dbo.Tmp_havi_keszlet', N'havi_keszlet', 'OBJECT' 
GO
ALTER TABLE dbo.havi_keszlet ADD CONSTRAINT
	PK_havi_keszlet PRIMARY KEY CLUSTERED 
	(
	datum,
	raktar_kod,
	cikk_szam,
	egyseg_ar
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT



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