/* 2013. november 14.16:46:12 User: sa Server: 192.168.59.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.vevok ADD eszamla char(1) NULL GO ALTER TABLE dbo.vevok SET (LOCK_ESCALATION = TABLE) GO COMMIT go update vevok set eszamla='0' go /* 2013. november 15.13:28:53 User: sa Server: 192.168.59.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_szlaf ADD Eszamla char(1) NULL GO ALTER TABLE dbo.vevo_szlaf SET (LOCK_ESCALATION = TABLE) GO COMMIT go update vevo_szlaf set eszamla='' go