Top "Insert" questions

Cannot insert explicit value because IDENTITY_INSERT is OFF, but cannot SET IDENTITY_INSERT to ON because it is already ON

I have a table in database Foo named Bar, that has a column named ID, which is the primary key, …

sql insert sql-server-2012 identity-column

Creating a CTE in Oracle

I am trying to create a CTE in Oracle that doesn't select from an existing table but instead has data …

sql oracle insert common-table-expression

MySQL LAST_INSERT_ID() used with multiple records INSERT statement

If I insert multiple records with a loop that executes a single record insert, the last insert id returned is, …

mysql insert lastinsertid

MySQL's INSERT IGNORE INTO & foreign keys

Why in MySQL, INSERT IGNORE INTO does not change the foreign key constraint errors into warnings? I'm trying to insert …

mysql insert foreign-keys ignore

NodeJS + Mongo: Insert if not exists, otherwise - update

I have an object in my mongodb collection. Its schema is: { "instruments": ["A", "B", "C"], "_id": { "$oid": "508510cd6461cc5f61000001" } } …

node.js mongodb insert exists updates

Inserting an IEnumerable<T> collection with Dapper errors out with "class is not supported by Dapper."

Yep, there are questions here and here about how to insert records with dapper-dot-net. However, the answers, while informative, didn't …

c# vb.net insert dapper

Problem with MySql INSERT MAX()+1

I have a single table containing many users. In that table I have column called user_id (INT), which I …

sql mysql insert max increment

Populate spinner with years dynamically in Android?

I have been racking my brain trying to get this to work. I want to dynamically enter in years from 1900 …

android dynamic insert spinner

Reserved word in column name - insert into MySQL

I have a MySQL database with the word "group" in one of the column names. I can't change this database …

mysql insert reserved-words

Getting new IDs after insert

I'm inserting a bunch of new rows into a table which is defined as follows: CREATE TABLE [sometable]( [id] [int] …

sql sql-server insert identity