Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Is It Possible To Generate a SQL Update Script For One Row Of Data?
- CREATE TABLE [User]
- [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
- [Name] [varchar](255) NOT NULL,
- [Address] [varchar](255) NOT NULL,
- [City] [varchar](100) NOT NULL,
- [State] [varchar](100) NOT NULL,
- [ZipCode] [varchar](100) NOT NULL,
- PRIMARY KEY CLUSTERED WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- UPDATE [User] SET
- [Name] = 'John Doe',
- [Address] = '132 Test Road',
- [City] = 'Anytown',
- [State] = 'TS',
- [ZipCode] = '12345'
- SELECT
- 'UPDATE [User] SET [Name] = ' +
- '''' + REPLACE(Name, '''', '''''') + '''' +
- ', [Address] = ' +
- '''' + REPLACE(Address, '''', '''''') + '''' +
- ... etc with remaining columns
- FROM [User]
- WHERE [User].ID = ...
Add Comment
Please, Sign In to add comment