Top "Insert" questions

SQL Insert trigger to update INSERTED table values

I want to create an Insert trigger that updates values on all the inserted rows if they're null, the new …

sql-server-2005 insert triggers

C++: insert char to a string

so I am trying to insert the character, which i got from a string, to another string. Here I my …

c++ string insert stringstream

INSERT rows into multiple tables in a single query, selecting from an involved table

I have two tables of the following form (i.e., every foo is linked to exactly one bar). CREATE TABLE …

sql postgresql insert common-table-expression

How to Access Sharepoint 2007/2010/2013 _layouts folder

I'm trying to insert some data in the location mysiteurl/_layouts/ 'cause I had to use a third part software …

sharepoint layout insert

SQL - Inserting a row and returning primary key

I have a little witty problem. Say, I inserted a row with some data in a table where a primary …

sql sqlite insert row primary-key

MySQL trigger On Insert/Update events

So I have two tables like this... ext_words ------------- | id | word | ------------- | 1 | this | ------------- | 2 | that | ------------- | 3 | this | ------------- ext_…

mysql triggers insert insert-update

MySQL: How to insert a record for each result in a SQL query?

Say I have a select SELECT DISTINCT id, customer_id, domain FROM config WHERE type = 'foo'; which returns some records. …

mysql sql loops insert

How to insertBefore() element in body tag?

I am trying to use insertBefore in js like this: var p = document.createElement("p"); p.innerHTML = "test1"; document.body.…

javascript dom insert getelementsbytagname

Oracle: Insert rowtype data into another table

I have one table called event, and created another global temp table tmp_event with the same columns and definition …

oracle plsql insert rowtype

Perform insert for each row taken from a select?

I have a number of records that I need to insert into multiple tables. Every other column will be a …

sql sql-server-2008 tsql insert