/****** Object:  UserDefinedDataType [dbo].[gyari_szam]    Script Date: 11/11/2009 16:48:03 ******/
CREATE TYPE [dbo].[gyari_szam] FROM [varchar](20) NOT NULL
go


/*
   2009. november 4.11:38:30
   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.keszlet ADD
	GYARI_SZAM gyari_szam NULL
GO
COMMIT

BEGIN TRANSACTION
GO
update keszlet set GYARI_SZAM=''
GO
COMMIT