Top "Insert-update" questions

A mixed flavour of data entry mode and data modification mode.

Updating tables without naming all columns

I have found a way to make two tables from different databases match each other using this template: INSERT [DestDB].[…

sql-server-2005 insert-update multiple-columns
zend framework 2 SQL update and insert affected rows (ZF2)

This is a simple question, but I've looked around and couldn't find the answer. How do I extract the number …

sql insert zend-framework2 insert-update error-checking
Primary key value after insertion of row in SQL Server 2005

In SQL Server 2005 I am inserting a row into a table using a stored procedure and I want to fetch …

sql-server-2005 stored-procedures primary-key insert-update
Django Updating Existing Model field

I have a model in Django with a foreign key to Django User Model. I am trying to update my …

django django-models django-forms insert-update updatemodel
how can i alter table in sqlite database through the obj c methods in iphone project

hii every one I need to add one column to my existing table so how can i alter table in …

iphone objective-c sqlite insert-update
Getting "Subquery returned more than 1 value" error running update query

Please be gentle, I am trying to update the query in sql server but facing an error. Here is my …

sql-server sql-server-2008 sql-update insert-update
How to pass string with ' ' (timestamp) in prepared statement?

I am trying to execute the following query INSERT INTO hotspot(timestamp) VALUES (timestamp with time zone '2012-10-25 14:00:00 +05:00…

postgresql syntax-error insert-update timestamp-with-timezone
SQL Server - update column based on another column value

How can I update a column in TableA value found in another table, Table B, depending on another column, Type, …

sql-server-2008 sql-update insert-update
Entity Framework - Insert with foreign key

Apologies if there is clear answer for this somewhere. But I can't insert into a simple table due to it …

c# entity-framework foreign-keys insert-update
Postgresql - Insert into where not exists using sqlalchemy's INSERT from SELECT

As pointed out here its possible to do the following with postgresql 9.1+ INSERT INTO example_table (id, name) SELECT 1, 'John' …

python postgresql sqlalchemy insert-update