Changing some script to include updating records

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Changing some script to include updating records

Author

Topic

kerrinbanner
Starting Member

1 Post

Posted - 2009-10-13 : 19:39:24

Hello

I am new to SQL. I have used a differencing tool to create a script which will be used to update a database schema. I wish to manually edit it to update the value in a field: My question is two fold: Where in the existing script should I insert it and secondly what to add to update the field value: I have attached the script I believe I wish to insert and an excerpt of the script automatically generated. Please can anyone tell me where to insert the sql script please?

Thanks Kerrin

HERE IS THE SCRIPT I BELIEVE I WANT TO ADD ( WHERE DO I ADD IT AND IS IT CORRCT ALSO?)

SCRIPT TO BE INSERTED IN TO CODE BELOW
USE trackersql
UPDATE Tbl_Alarms
Set MainCategory='Intruder'
WHERE MainCategory=NULL

HERE IS THE AUTO GENERATED SCRIPT INTO WHICH I WISH TO INSERT THE CODE ABOVE
/* ------------------------------------------------------------

DESCRIPTION: Schema Synchronization Script for Object(s)

tables:
[dbo].[Tbl_AlarmComponents], [dbo].[Tbl_Alarms], [dbo].[Tbl_Company_Info], [dbo].[Tbl_Devices], [dbo].[Tbl_Job], [dbo].[Tbl_JobCosting], [dbo].[Tbl_Keyholders], [dbo].[Tbl_Quote], [dbo].[Tbl_QuoteCosting]

Make WIN-7ESGOGRYKDN.trackerSQL Equal WIN-7ESGOGRYKDN.trackerSQL

AUTHOR: Kerrin Banner

DATE: 13/10/2009 00:06:37

LEGAL: XXXXX.

------------------------------------------------------------ */

SET NOEXEC OFF
SET ANSI_WARNINGS ON
SET XACT_ABORT ON
SET IMPLICIT_TRANSACTIONS OFF
SET ARITHABORT ON
SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
GO
USE [trackerSQL]
GO

BEGIN TRAN
GO

-- Drop Extended Property MS_ColumnHeads from Tbl_AlarmComponents
Print 'Drop Extended Property MS_ColumnHeads from Tbl_AlarmComponents'
GO
EXEC sp_dropextendedproperty N'MS_ColumnHeads', 'SCHEMA', N'dbo', 'TABLE', N'Tbl_AlarmComponents', 'COLUMN', N'Supplier'
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Drop Extended Property ColumnOrder from Tbl_AlarmComponents
Print 'Drop Extended Property ColumnOrder from Tbl_AlarmComponents'
GO
EXEC sp_dropextendedproperty N'ColumnOrder', 'SCHEMA', N'dbo', 'TABLE', N'Tbl_AlarmComponents', 'COLUMN', N'CCTVMemo'
GO

IF @@TRANCOUNT>0
COMMIT

SET NOEXEC OFF

Kerrin S Banner

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources