After completing this chapter, you will be able to:
Update information in your databases
Manage update issues by using triggers
Use ADO.NET components to perform update operations
You use the UPDATE statement to modify information in your data tables. The basic syntax for updates is the following:
UPDATE [<ServerName>].[<Database>].[<Schema>].[<TableName>] SET [<ColumnName>] = <NewValue>> ,.... WHERE <Search Conditions,,>
As usual, if you execute the UPDATE sentence with a connection to the current database, you can simply use the <SchemaName>.<TableName> form without including the server and database names.
You can use the UPDATE sentence without a WHERE condition. A ...