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
Remove duplicate rows in SQL Server
Assuming no nulls, you GROUP BY the unique columns (eg. col_1, col_2, col_3), and SELECT the MIN (or MAX) Row ID (eg. row_id) as the row to keep. Then, delete everything that didn’t have a row id: DELETE my_table FROM my_table LEFT OUTER JOIN ( SELECT MIN(row_id) as row_id, col_1, ... Read more
About Oracle error “Cannot load OCI DLL”
When you use Oracle tools that call Oracle client dll “oci.dll”, you may meet this error. [caption id="attachment_1847" align="alignnone" width="366"] Cannot load OCI DLL[/caption] When you use these Withdata ... Read more
Batch replace string in WordPress posts
I want to change a link, from text link to image link, like: <a href=”abc.zip”>download</a> to <a href=”abc.zip”><img src=”/images/download.gif” alt=”download” /></a> And this link is not in one post, but some posts, it ... Read more
How to get column names from DB2 table
SELECT colname, typename, length, scale, default FROM syscat.columns WHERE tabname = “<table name>” AND tabschema = “<schema name>” See also: How to get column names from Sql Server table How to get column names from Oracle table How to get column names from ... Read more