Tag: import

How to import values from csv to SqlServer using c#

I have come across this problem.I am trying to import data into a database from a csv file.Normally the insert part works,but now I keep getting an error: Arithmetic overflow error converting int to data type numeric . The statement has been terminated.It is probably because I have id as the first property,but if I “shift” the array by omitting

Update Text Field on Multiple Rows Using Current Text In Field SQL

import sql sql-server ssms string

I have a table with a text field that imported with incorrect characters delimited by a space. Expected Output I need to run an update to remove all the text AFTER the space on a specific number of rows. I figured out a way to select the correct text, but I’m stuck on how to update in bulk. Will return

Getting IMP-00403 warning when using IMP (12.2.0.1.0) but the generated import_sys.sql which failed is empty

import oracle sql

I have an Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 on Windows 2019 (64bit). In short, when importing a dump file I’m getting the following: IMP-00403: Warning: This import generated …

Is Power BI Best Practice to Group Data in the SQL Query Before Importing even though this may effect how you write some DAX expressions later?

import powerbi sql

I’m importing data via SQL import to a Power BI data model. If I group the data I can save the import 100,000 rows, but it effect the way I write my DAX queries to get the correct answer (and makes them slightly more complex). I’m after the general best practice for where to group data, pre import, or post

ERROR 1148: The used command is not allowed with this MySQL version

import mysql sql

I am trying to load data into mysql database using the topic of this question is the response I get. I understand the local data offloading is off by default and I have to enable it using a the command local-infile=1 but I do not know where to place this command. Answer You can specify that as an additional option

How do you import a large MS SQL .sql file?

import sql sql-server

I use RedGate SQL data compare and generated a .sql file, so I could run it on my local machine. But the problem is that the file is over 300mb, which means I can’t do copy and paste because the …

Loading .sql files from within PHP

import mysql php scripting sql

I’m creating an installation script for an application that I’m developing and need to create databases dynamically from within PHP. I’ve got it to create the database but now I need to load in …