Guest User

Untitled

a guest
Aug 17th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. Is It Possible To Generate a SQL Update Script For One Row Of Data?
  2. CREATE TABLE [User]
  3. [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
  4. [Name] [varchar](255) NOT NULL,
  5. [Address] [varchar](255) NOT NULL,
  6. [City] [varchar](100) NOT NULL,
  7. [State] [varchar](100) NOT NULL,
  8. [ZipCode] [varchar](100) NOT NULL,
  9. PRIMARY KEY CLUSTERED WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  10. ) ON [PRIMARY]
  11.  
  12. UPDATE [User] SET
  13. [Name] = 'John Doe',
  14. [Address] = '132 Test Road',
  15. [City] = 'Anytown',
  16. [State] = 'TS',
  17. [ZipCode] = '12345'
  18.  
  19. SELECT
  20. 'UPDATE [User] SET [Name] = ' +
  21. '''' + REPLACE(Name, '''', '''''') + '''' +
  22. ', [Address] = ' +
  23. '''' + REPLACE(Address, '''', '''''') + '''' +
  24. ... etc with remaining columns
  25. FROM [User]
  26. WHERE [User].ID = ...
Add Comment
Please, Sign In to add comment