/*
   2009. március 12.10:06:15
   User: sa
   Server: 192.168.1.85,1137
   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.vevo_arcsoport ADD
	penznem dbo.penznem NULL
GO

update vevo_arcsoport set penznem=dbo.xrfuggveny('AlapPenznem')
go
COMMIT
go

/*
   2009. március 12.13:15:19
   User: sa
   Server: 192.168.1.85,1137
   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.vevo_akc_csoport ADD
	penznem dbo.penznem NULL
GO

update vevo_akc_csoport set penznem=dbo.xrfuggveny('AlapPenznem')
go

COMMIT
go