insert Archives - IT Nursery

Mysql load from infile stuck waiting on hard drive

I’ve got a windows 7 64 bit machine that I’m using for some load testing of a mysql db. My program uses sqlalchemy … Read more

Select one name per person where spelling variations exist

by IT Nursery

I have a source table that contains Employee IDs and names. The employee names may be listed multiple times with variations on the … Read more

Subquery in the VALUES clause

by IT Nursery

Here’s a real-world schema: CREATE TABLE [dbo].[Setting] ( [ID] [BIGINT] NOT NULL, [Module] [NVARCHAR](400) NOT NULL, [Property] [NVARCHAR](400) NOT NULL, [Value] [NVARCHAR](4000) NULL, … Read more

SQL 2012 insert data into a table from another table and custom columns

by IT Nursery

I’m trying to insert data from one table into another table and I also have 4 columns that are not in the source … Read more

INSERT into three tables with many-to-many from one table

by IT Nursery

Pass Parameters to trigger function to execute dynamic SQL

by IT Nursery

I have this code which was solved by Erwin: Execute dynamic INSERT ON CONFLICT DO UPDATE in plpgsql function Now I want the … Read more

Negative number of rows inserted

by IT Nursery

I just ran a rather simple INSERT statement (that I think processed a lot of rows), and I got the message: -1,311,750,183 rows … Read more

Speeding up insert in SQL Server

by IT Nursery

I have a stored procedure which inserts some records in a few tables. In couple of tables at least , the inserted records … Read more

INSERT performance degradation in SQL Server after a certain number of columns

by IT Nursery

I’m working on an application which has a feature of export of tabular data into a specified database table. The app uses INSERT … Read more

Want to know whether an ‘UPSERT’ operation performed INSERT or UPDATE

by IT Nursery

I have a query where I try to insert a record and ready to update in case the record exists. The question is … Read more