I have a table:
CREATE TABLE [dbo].[New Sector Change](
[operation_ver_id] [nvarchar](255) NOT NULL,
[OPERATION TYPE_ID_OLD] [smallint] NOT NULL,
[OPERATION_TYPE] [smallint] NOT NULL
) ON [PRIMARY];
Sample records are:
operation_ver_id OPERATION TYPE_ID_OLD
OPERATION_TYPE
4B202FFF-0F4B-4B7B-824E-7DADAA863517 93
88
0C8B5B20-F572-4DA2-9775-7E933A0D3037 93
88
7364F748-2112-431F-BC40-64B380847FAE 93
88
CFE436BF-8B66-4EA4-933B-58AAA466570B 93
88
B631EB1E-CF3D-4DE7-9E90-DABDC857AB8E 93
There are about 2000 rows in the table. I loaded it from an Excel spreadsheet.
I need to generate an UPDATE script of the type for all 2000 rowsHow can this be done?:
UPDATE dbo.[New Sector Change]
SET OPERATION_TYPE =90
WHERE OPERATION_VER_ID = '4B202FFF-0F4B-4B7B-824E-7DADAA863517';