/*
   2015. május 4.11:18:07
   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_szall_szl_fizetve
	(
	biz_tipus char(10) NULL,
	bizszam varchar(50) NOT NULL,
	fiz_datum dbo.datum NULL,
	fizetve char(1) NOT NULL,
	hatralek dbo.egyseg_ar NULL,
	fizetett dbo.egyseg_ar NULL,
	kicsoda dbo.kicsoda NULL,
	keszult dbo.datum_ora NULL,
	ut_fizetes dbo.egyseg_ar NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_szl_fizetve SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_szl_fizetve)
	 EXEC('INSERT INTO dbo.Tmp_szall_szl_fizetve (biz_tipus, bizszam, fiz_datum, fizetve, hatralek, fizetett, kicsoda, keszult, ut_fizetes)
		SELECT biz_tipus, CONVERT(varchar(50), bizszam), fiz_datum, fizetve, hatralek, fizetett, kicsoda, keszult, ut_fizetes FROM dbo.szall_szl_fizetve WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szall_szl_fizetve
GO
EXECUTE sp_rename N'dbo.Tmp_szall_szl_fizetve', N'szall_szl_fizetve', 'OBJECT' 
GO
COMMIT



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