Withdata software has announced xlstomdb 2.5, a data conversion tool that import Excel data to Access database. XlsToMdb 2.5 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToMdb – A better way to import Excel ... Read more
Withdata Software Released XlsToDB2 Version 1.9
Withdata software has announced xlstodb2 1.9, a data conversion tool that import Excel data to DB2 database. XlsToDB2 1.9 add “Task Schedule”, add support to XML type field, improve import performance, and fix “division by zero” bug in importing process. XlsToDB2 – A ... Read more
Withdata Software Released TxtToSql Version 2.5
Withdata software has announced txttosql 2.5, a data conversion tool that import csv(txt) data to SQL Server database. TxtToSql 2.5 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. TxtToSql – A better way to import ... Read more
Withdata Software Released TxtToMy Version 2.1
Withdata software has announced txttomy 2.1, a data conversion tool that import csv(txt) data to MySQL database. TxtToMy 2.1 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. TxtToMy – A better way to import ... Read more
Withdata Software Released TxtToDB2 Version 1.9
Withdata software has announced txttodb2 1.9, a data conversion tool that import csv(txt) data to DB2 database. TxtToDB2 1.9 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. TxtToDB2 – A Better Way to import ... Read more
Withdata Software Released CsvToAccess Version 2.4
Withdata software has announced csvtoaccess 2.4, a data conversion tool that import csv(txt) data to Access database. CsvToAccess 2.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. CsvToAccess – A Better Way To ... Read more
How to create a user in SQL Server Express database
Create a SQL Authenticated login first with CREATE LOGIN, then add a user associated with that login to your database by using CREATE USER. USE [master] GO CREATE LOGIN [YourUsername] WITH PASSWORD=N'YourPassword', DEFAULT_DATABASE=[YourDB], CHECK_EXPIRATION=OFF, ... Read more
Change MySQL table character set from latin1 to utf8
I have a table “t_user”, it’s character set is “latin1” when create it, and I want to save some unicode text at field “username”, but when I saved, the data is “????”, so I need to change character set from “latin1” to ... Read more
The DB2 equivalent for the MySQL Limit
In MySQL, you can use “Limit n,m”, like this: select * from sometable order by name limit 20,10 And in DB2, use this query: SELECT * FROM (SELECT * FROM sometable ORDER BY name DESC fetch first {start} rows only ) AS mini ORDER BY mini.name ASC fetch first {total} rows ... Read more
The SQL Server equivalent for the MySQL Limit
In MySQL, you can use “Limit n,m”, like this: select * from sometable order by name limit 20,10 And in SQL Server, use this query: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as rowNum FROM sometable ) sub WHERE rowNum > 20 AND ... Read more