Withdata software has announced db2tomssql 1.2, a data conversion tool that convert DB2 data to SQL Server database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToMsSql – Convert DB2 data to SQL ... Read more
Author Archives: Shiji Pan
Withdata Software Released DB2ToAccess Version 2.1
Withdata software has announced db2toaccess 2.1, a data conversion tool that export DB2 data to access. DB2ToAccess 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToAccess – Better tool for exporting DB2 data to ... Read more
Withdata Software Released AccessToOracle Version 2.1
Withdata software has announced accesstooracle 2.1, a data conversion tool that import Access data to oracle. AccessToOracle 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToOracle – Better tool for importing ... Read more
Withdata Software Released AccessToMysql Version 2.1
Withdata software has announced accesstomysql 2.1, a data conversion tool that import Access data to mysql. AccessToMysql 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToMysql – Better tool for importing ... Read more
Withdata Software Released AccessToMsSql Version 2.1
Withdata software has announced accesstomssql 2.1, a data conversion tool that import Access data to ms SQL server. AccessToMsSql 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToMsSql, Better way to import Access ... Read more
Withdata Software Released AccessToDB2 Version 2.1
Withdata software has announced accesstodb2 2.1, a data conversion tool that import Access data to db2. AccessToDB2 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToDB2 – Better tool for importing Access data ... Read more
Replace (Update/Insert) a row into SQL Server table
In MySQL, we use “ON DUPLICATE KEY UPDATE” to either updates or inserts a row in a table. How to do it in SQL Server? Just like this: if not exists (select 1 from employees where employee_id = 1) insert into employees (employee_id,last_name,first_name) values ( 1,'smith', ... Read more
Replace (Update/Insert) a row into Oracle table – Merge into
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in Oracle? Use “merge into” . MERGE INTO employees USING dual ON ( "id"=123456 ... Read more
For Feed Shark
www.HyperSmash.com ... Read more
Remove duplicate rows in MySQL
The primary key: id, the unique columns: col_1, col_2, col_3 . You can use a temporary table, like: create temporary table temp_table (id int); insert temp_table (id) select id from your_table t1 where exists ( select * from your_table t2 ... Read more