Collections:
Updating Values with UPDATE Statements in SQL Server
How To Update Values in a Table with UPDATE Statements in SQL Server?
✍: FYIcenter.com
If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example:
SELECT * FROM fyi_links WHERE id = 101 GO id url notes counts created 101 dev.fyicenter.com NULL 0 2006-04-30 UPDATE fyi_links SET counts = 999, notes = 'Good.' WHERE id = 101; GO (1 row(s) affected) SELECT * FROM fyi_links WHERE id = 101 GO id url notes counts created 101 dev.fyicenter.com Good. 999 2006-04-30
As you can see, the SET clause takes column and value pairs to provide new values, while the WHERE clause defines which row to apply the update.
⇒ Updating Multiple Rows with One UPDATE Statement in SQL Server
⇐ Inserting Multiple Rows with One INSERT Statement in SQL Server
2016-11-02, 1401🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...