Tag: insert

Sometimes, you need to convert SQL insert statement to SQL update statement, you can use Withdata DataFileConverter, easy and fast. For example, you have a file employees_insert.sql, contains 2 SQL insert statements for SQL Server: insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) values (90,’King’,’Steven’,’AD_PRES’,24000,’SKING’,null,null,’515.123.4567′,100,’6/17/1987′) ; insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) values (90,’Kochhar’,’Neena’,’AD_VP’,17000,’NKOCHHAR’,100,null,’515.123.4568′,101,’9/21/1989′) ; Use DataFileConverter, start a new task,…