Top "Sql-update" questions

An SQL UPDATE statement is used to change existing rows in a table.

Update statement to update multiple rows

I have a question regarding the following syntax. Is there a cleaner way to roll this up into one statement …

sql-server sql-update
How to update a varbinary field with a specific value?

Basically I am trying to give a user a certain password so I can test some functionality on a system, …

sql sql-server-2008 sql-server-2008-r2 sql-update varbinary
Insert line break in postgresql when updating text field

I am trying to update a text field in a table of my postgresql database. UPDATE public.table SET long_…

postgresql char sql-update
Get count of records affected by INSERT or UPDATE in PostgreSQL

My database driver for PostgreSQL 8/9 does not return a count of records affected when executing INSERT or UPDATE. PostgreSQL offers …

sql postgresql sql-update
Bulk update mysql with where statement

How to update mysql data in bulk ? How to define something like this : UPDATE `table` WHERE `column1` = somevalues SET `column2` = …

mysql sql-update bulk
Updating integer column with null values in postgres

I would like to update my column with other column in other table. Before doing so, I would like to …

postgresql null sql-update alter
SQL Server Update Trigger, Get Only modified fields

I am aware of COLUMNS_UPDATED, well I need some quick shortcut (if anyone has made, I am already making …

sql sql-server triggers sql-update database-replication
Sql query for updating database if value is not null?

I am having a table which has about 17 fields. I need to perform frequent updates in this table. But the …

sql database sqlite sql-update
How to update data as upper case first letter with t-sql command?

I have a table on my database. My table's name is "Company". I want to change data "company_name" as …

sql-server tsql sql-update uppercase
What are differences between INSERT and UPDATE in MySQL?

It seems INSERT and UPDATE do the same things to me. Is there any occasions where I should use INSERT …

mysql sql sql-update sql-insert