How do I update a single row in a SQL Server database? -
How can I update a line? I have a SQL Server database of 34 rows fe SYSTIMESTATE (14.10.2014 08: 01: 15: 000) and I will replace it with (04.11.2014 08 : 01: 15: 000) How can I do this? Statement is SELECT with the statement UPDATE : select from EXDOCS * where SYSTIMESTATE = '14.10.2014 08: 01: 15: 000 '' set the update EXDOCS SYSTIMESTATE = '04 .11.2014 08: 01: 15: 000 'WHERE SYSTEMSTATE = '14 .10.2014 08: 01: 15: 000' Also learn how to come up with a solution: